JCL sorting.

ppandey07 · Posted: Tue May 22, 2012 1:23 pm

Hi there,

I have two files of same LRECL and have same data.
I want to sort these files via four fields and want to remove duplicates only via those four fields.
Now there is one more field in the files(different than sorted fields),
and on the basis of this field, I want to remove duplicates.
Can you please help me with that?

Bill Woodger · Posted: Tue May 22, 2012 1:42 pm

If you want to remove duplicates, you'll need to sort on the fifth field as well, else how is anything to know about all the duplicates?

Then, what is wrong with SUM FIELDS=NONE?

If that isn't going to work for you, you'll have to explain it better, with examples of the input and the expected output for that input.

It is irrelevant if there are two files and you are going to sort them together, it is one file by the time the sort sees it.

ppandey07 · Posted: Tue May 22, 2012 2:19 pm

Bill Woodger · Posted: Tue May 22, 2012 2:50 pm

So, OPTION EQUALS, sort on four fields. SUM FIELDS=(NONE)

Try it.

dbzTHEdinosauer · Posted: Tue May 22, 2012 2:59 pm

as long as the concatenation of files in SORTIN is file with 'A' first.

Bill Woodger · Posted: Tue May 22, 2012 3:04 pm

Worth pointing out. Pankaj, don't just "say" it, make it so, else you'll get the wrong ones.

EDIT: That means document it that way as well, so someone "cleverer" than you doesn't "correct" the order of the files because it is somehow neater, or something dumb like that.