Frank Yaeger Sort Forum Moderator

Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Tue Sep 19, 2006 12:44 pm Post subject: |
|
|
You need to provide more information than that. A VB file usually has variable length records, so the last 4 characters would be in different positions in different records and sorting on those characters would probably not make a lot of sense.
Is every record actually the same length with fixed length fields? If so, what is the starting position of the 4-byte field you want to sort on (remember that a VB record has the RDW in positions 1-4 so the first data byte starts in position 5).
Are the fields actually variable length and delimited in some way (e.g. comma separated values). If so, what is the layout of the fields and which field do you want to sort on?
Give more details so we can understand what you're trying to do and help. An example of the records in the input file and the expected output records would be helpful. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|