Sort file containing HDR/TRL and remove duplicates



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Sort file containing HDR/TRL and remove duplicates

Postby jyoti_tyagi82 » Fri Mar 08, 2013 7:30 pm

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
jyoti_tyagi82
 
Posts: 1
Joined: Fri Mar 08, 2013 7:22 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort file containing HDR/TRL and remove duplicates

Postby BillyBoyo » Fri Mar 08, 2013 8:09 pm

Mmmm.... is this a duplicate of the question in the Expert's forum?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post