Joined: 26 Nov 2002 Posts: 12357 Topics: 75 Location: San Jose
Posted: Thu Aug 31, 2017 11:42 am Post subject:
Magesh_J,
For IFTRAIL, the trailer record will not be treated as a data record; all other OUTFIL processing (for example, INCLUDE, OMIT, BUILD, OVERLAY, and so on) will be bypassed for the trailer record. The updated count and total values will not include the trailer record.
So in essence IFTRAIL should be referring to the ORIGINAL record.
If you explain what you trying to do with IFTRAIL, then there may be other ways to incorporate what you want to do. _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Joined: 26 Nov 2002 Posts: 12357 Topics: 75 Location: San Jose
Posted: Thu Aug 31, 2017 4:20 pm Post subject:
Magesh_J,
I am not sure as to why you complicate a simple request. If your goal is just to remove duplicate records, then it is quite easy. Use SELECT operator with NODUPS to get unique records. And if you want to retain the header and trailer in their original place, use ALTSEQ to override their values.
Alternatively if you don't care about the header and trailer simply OMIT them and create them after using header1 and trailer1. Simply change the CTL1CNTL to the following.
Joined: 26 Nov 2002 Posts: 12357 Topics: 75 Location: San Jose
Posted: Fri Sep 01, 2017 10:38 am Post subject:
Magesh_J wrote:
Hi Kolusu,
Thanks for the solution.
Regards,
Magesh
Magesh_J,
You do realize that ALTSEQ does NOT actually change the data, the change is applied ONLY to the sorting and the input stays the same? _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum