IBM Mainframe Forum

Dear friend
I want a methode to extract one instance of records which contain same data on coloumn 11 to 15. For example if SORTIN like below:

Out put must be below:

How about using ?

A clarification:

You can use SUM with MERGE. You can use MERGE with one file. Therefore, if a file is in sequence already, MERGE with SUM will use less resources than SORT with SUM.

It is one of those things. "We" know that a file is in sequence before the step is run. SORT only knows when it has already read the last record, at the earliest.

If the file is not in sequence, MERGE will tell you, and you'll have to use SORT anyway.

You cannot use SUM with SORT FIELDS=COPY/OPTION COPY. You can specify it, but it won't do anything.

For the MERGE you will need to change SORTIN to SORTIN01. If you were merging, say, four files, they would be SORTIN01, ...02, ...03, ...04.

These users thanked the author BillyBoyo for the post (total 2):

sureshas12 (Tue Nov 06, 2012 3:10 pm) • Mehdi shri (Wed Oct 17, 2012 10:19 am)