|
View previous topic :: View next topic
|
| Author |
Message |
Ramsee
New User
.jpg)
Joined: 06 Jan 2011
Posts: 53
Location: Chennai
|
|
|
|
Hi,
I need to skip the first line of the file using SORT.
Sample I/P:
| Code: |
*---+----1----+----2----+----3----+----4----+----5----+----6
12347 aaaaaa
12348 bbbbbb
12342 ccccccc
|
Sample O/P:
| Code: |
12342 ccccccc
12347 aaaaaa
12348 bbbbbb
|
Regards,
Ramsee |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Suggest you read about SKIPREC In the DFSORT documentation.
You might also use the forum SEARCH (above in the blue line).
There are several ways to do this . . . |
|
| Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
|
|
Ramsee,
Based on your sample output, I am assuming that you want output sorted by field starting at first position for 5 bytes and that being ZD field. If it is something else, change sort fields definition accordingly.
| Code: |
OPTION SKIPREC=1,EQUALS
SORT FIELDS=(1,5,ZD,A)
|
Thanks, |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Ramsee,
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:
www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000080 |
|
| Back to top |
|
|
|
|
