Sort only detail records
Posted: Fri Nov 04, 2016 9:25 am
Hi Team,
I have an input file as mentioned below
I would need the output as mentioned below.
HD HEADER 1234567
LN TRAILER 1111
LN TRAILER 2222
LN TRAILER 3333
LN TRAILER 4444
LN TRAILER 5555
HD HEADER 2345678
LN TRAILER 2111
LN TRAILER 2221
LN TRAILER 2333
LN TRAILER 2444
LN TRAILER 2555
I used below mentioned SORT card but its working if there is only one header but my input file can contain more than one header.
Could anyone please assign me with this?
I have an input file as mentioned below
HD HEADER 1234567
LN TRAILER 1111
LN TRAILER 3333
LN TRAILER 5555
LN TRAILER 4444
LN TRAILER 2222
HD HEADER 2345678
LN TRAILER 2111
LN TRAILER 2333
LN TRAILER 2555
LN TRAILER 2444
LN TRAILER 2221
LN TRAILER 1111
LN TRAILER 3333
LN TRAILER 5555
LN TRAILER 4444
LN TRAILER 2222
HD HEADER 2345678
LN TRAILER 2111
LN TRAILER 2333
LN TRAILER 2555
LN TRAILER 2444
LN TRAILER 2221
I would need the output as mentioned below.
HD HEADER 1234567
LN TRAILER 1111
LN TRAILER 2222
LN TRAILER 3333
LN TRAILER 4444
LN TRAILER 5555
HD HEADER 2345678
LN TRAILER 2111
LN TRAILER 2221
LN TRAILER 2333
LN TRAILER 2444
LN TRAILER 2555
I used below mentioned SORT card but its working if there is only one header but my input file can contain more than one header.
INREC IFTHEN=(WHEN=GROUP,BEGIN=(1,2,CH,EQ,C'LN'),PUSH=(168:12,4))
SORT FIELDS=(168,4,CH,A),EQUALS
SORT FIELDS=(168,4,CH,A),EQUALS
Could anyone please assign me with this?