SORTing based on a particular field in 1st record ofa GROUP
Posted: Tue Oct 04, 2011 10:53 pm
Hi Everyone !!
Here is what i am trying to accomplish :- I have a file with a set of records. I have categorized the file into different groups based on the below criteria; {Header(H), Detail records(D), Trailer(S) }
INREC IFTHEN=(WHEN=GROUP,
BEGIN=(1,1,CH,EQ,C'H'),
END=(1,1,CH,EQ,C'S'),
PUSH=(201:ID=5,SEQ=5))
SORT FIELDS=COPY
OUTFIL BUILD=(1,210)
I now want to SORT each group in such a way that all the GROUPs should come together for which the value at position 50 (15 chars length) of the FIRST (HEADER) record in each group are EQUAL. Can someone please give me a direction here.
Thank you.
Rajesh.
Here is what i am trying to accomplish :- I have a file with a set of records. I have categorized the file into different groups based on the below criteria; {Header(H), Detail records(D), Trailer(S) }
INREC IFTHEN=(WHEN=GROUP,
BEGIN=(1,1,CH,EQ,C'H'),
END=(1,1,CH,EQ,C'S'),
PUSH=(201:ID=5,SEQ=5))
SORT FIELDS=COPY
OUTFIL BUILD=(1,210)
I now want to SORT each group in such a way that all the GROUPs should come together for which the value at position 50 (15 chars length) of the FIRST (HEADER) record in each group are EQUAL. Can someone please give me a direction here.
Thank you.
Rajesh.