mainframegurukul.com

What do you mean by vulnerable code?

It is not considered cool to cross-post the forums at the same time.

At last.

What is the maximum number of detail records? LRECL and RECFM?

Is this a once-off (data fix) or a regulat task (if yes, why?).

OK, but SORT has no support for colour-recognition. How is SORT supposed to know the group is duplicate? Note, this is the same question, you provided nothing with this "cute" answer.

How do you know it is duplicate?

You have SyncSORT, which does not have NOSEQCK, so just remove that.

With a variable number of variable-length data items (you could have A E I O U Incorporated, you could have dashes, numbers) and with variable-length data following what you want to extract, it is not going to be convenient. SORT has no loop-constructs. Although your field is second-from-the-end, th...

Your date is in a bad format for useful comparisons.

You need to treat the year, month and day separately.

Or, reformat your date in INREC in a temporary extension to the recird, and use OUTIFL INCLUDE= with BUILD to return your records to the original size.

SPAM

The you use PARSE, to find the "-" and pick up that and the four characters after it, and then set the parse-pointer back 10 and pick up the first five characters. This assumes that you don't have a "-" anywhere else prior to that. Not always true for a name. OPTION COPY INREC PARSE=(%01=(ST...

The first part of your data is in a fixed position, the thing is to get the final part also in a fixed position. You can use JFY with SHIFT=RIGHT to do that. Once you've got all the data you want in fixed positions, it is simple with BUILD. OPTION COPY INREC IFTHEN=(WHEN=INIT, OVERLAY=(51:7,...

Well, I was hoping you'd show the one that you declared as "not working" so we could polish that one.

You use JOINKEYS, with the same dataset for both inputs. In JNF1CNTL, you use INREC with WHEN=GROUP to PUSH an ID to a temporary extension to the record. This ID field will be your key for the first JOINKEYS statement, where you also specify SORTED,NOSEQCK. In JNF2CNTL you using INCLUDE to identify ...

It can be done with SORT.

Can you post the code you tried, please?

Well, of course it doesn't work. You've changed the spec.