Page 1 of 1

Sort file containing HDR/TRL and remove duplicates

PostPosted: Fri Mar 08, 2013 7:30 pm
by jyoti_tyagi82
Hi,

I have an input file containing header & trailer.

a) Key field starts Pos1 and length = 10
b) file has RECFM=FB and LRECl=80
header contains word 'HEADER' + other fields
Trailer contains word 'TRAILER' + other fields

My requirement :
1. Sort the file based on Key field excluding Header & trailer
2. Write all records which are duplicates (based on key field values) to another file.

I can do it in 2 steps but need to do both above in one Step only.

Please help. Thanks

Re: Sort file containing HDR/TRL and remove duplicates

PostPosted: Fri Mar 08, 2013 8:09 pm
by BillyBoyo
Mmmm.... is this a duplicate of the question in the Expert's forum?