| View previous topic :: View next topic |
| Author |
Message |
dubasir
Beginner
Joined: 13 Dec 2004
Posts: 20
Topics: 9
|
 Posted: Thu Jan 14, 2010 7:43 am Post subject: SORT CARD |
 |
|
Hi,
I have a file which is sorted on 1 to 7 charecters. This file has header positioned at end. After sorting header comes first and rest of the records next. This was fine since records other than header are numeric.
Now this field has alphanumeric values to. The same sort condition did not work here and header record may come in middle. How can i do a sort such that header record should come first and other records to sorted and placed below. |
|
| Back to top |
|
 |
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Thu Jan 14, 2010 12:17 pm Post subject: |
|
|
You can use the DATASORT operator of DFSORT's ICETOOL to do that. The technique is discussed in the "Sort detail records between headers and trailers" Smart DFSORT Trick at:
http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094
You can omit the TRAILER keyword since you don't have a trailer.
_________________
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 |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
