View previous topic :: View next topic
|
Author |
Message |
Avinash_Gupta
New User
Joined: 11 May 2005 Posts: 26 Location: Hyderabad
|
|
|
|
I have a problem while sorting a file which has header and detail records. But there are no header identifier as such. It just has fewere fields as compared to detail records.
I have to sort the detail records leaving out the header. Please let me know if there is a way to accomplish it.
Input:
2007052800005020000-------------------->header
20070528055420020009976788---------->details
20070528058160080009965234
20070528045670060009821342
20070528027540030006745434
20070528000300010002342352----------->details
Ouput:
2007052800005020000
20070528000300010002342352
20070528027540030006745434
20070528045670060009821342
20070528055420020009976788
20070528058160080009965234
We are sorting on the detail record starting from the field (9,5) 9 is the starting position and 5 is the lenght. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use the technique shown in the "Sort records between a header and trailer" Smart DFSORT Trick at:
www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
Quote: |
It just has fewere fields as compared to detail records. |
You can use that fact to identify the header record, e.g.
20,3,CH,EQ,C' ' |
|
Back to top |
|
|
|