Add a Unique Row Index

swapnadeep.ganguly · Active User Joined: 21 Mar 2007 Posts: 203 Location: India

Hi All,

I want to add a Unique Row Index (Line number is the best Unique Row Index to me). Is there any method in DFSORT my means of which, we can easily add the same to my record.

Let us assume my input as

expat · Posted: Mon Oct 19, 2009 3:10 pm

What is the RECFM and LRECL of the input dataset.
How many records do you estimate will be in the file.

The code below works for me - adding a space and a 5 byte sequence number to the end of a 60 byte FB record

swapnadeep.ganguly · Active User Joined: 21 Mar 2007 Posts: 203 Location: India

The RECFM is FB and the LRECL is 82.

So, the code that should work for me (without the space) should be:

Frank Yaeger · Posted: Mon Oct 19, 2009 9:06 pm

That will work, but you can do it more simply with DFSORT's OVERLAY function like this:

swapnadeep.ganguly · Active User Joined: 21 Mar 2007 Posts: 203 Location: India

Thank you Frank for providing this Tutorial..

Thank you all for providing the quick responses as the solutions provided by you all worked for me...