How to handle variable length record in SORT.

avalanches · New User Joined: 10 May 2005 Posts: 28

Hi,

I want to sort a variable length record. So, when I need to specify the starting position of the elements based on which the records to be sorted, should I give the starting position as we see in the file OR should I add 4 to the starting position as we see in the file?

Thanks,
Cheers.

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 486

Hi Avalanches,

You want to sort the variable lengthe file?

Please confirem

Regards
Rupesh

nallapureddy · New User Joined: 27 Jul 2005 Posts: 18

Hi,

Yeah u should be adding 4 bytes to the starting byte for the VB file.

Thanks,
Madhavi

Frank Yaeger · Posted: Wed Aug 31, 2005 8:49 pm Post subject:

For VB records, the first data byte starts in position 5 after the 4-byte RDW. When you view the records, the RDW is often hidden, but it's still there as far as DFSORT is concerned. You need to include the RDW when specifying the starting position, so you'd add 4 to the starting position of the data byte. For example, for the second data byte, you'd specify a starting position of 6 (4 for RDW + 2).

avalanches · New User Joined: 10 May 2005 Posts: 28

Thanks much guys. I had tested to find out this.

Lesson Learned: Do yourself as much b4 seeking the help!

Cheers.