View previous topic :: View next topic |
Author |
Message |
ZY24 Beginner
Joined: 29 Mar 2007 Posts: 6 Topics: 2 Location: Birmingham, Alabama
|
Posted: Thu Mar 29, 2007 10:48 am Post subject: LIMITING recs and SORTING in one step |
|
|
Can I sort the recs in desc order first then keep only the top 1000 and do this in one step?
In this example I get the first 1000 recs sorted in desc order not the entire file.
SORT FIELDS=(14,22,D),FORMAT=BI,STOPAFT=1000
I know I can do it in two steps. First step just sort in desc and then a SORT=COPY, STOPAFT=1000 but how do I combine this into one SORT step?
Thanks in advance,
ZY24 |
|
Back to top |
|
|
amargulies Beginner
Joined: 10 Jan 2007 Posts: 123 Topics: 0
|
Posted: Thu Mar 29, 2007 10:56 am Post subject: |
|
|
ZY24,
Try this:
Code: |
SORT FIELDS=(14,22,BI,D)
OUTFIL ENDREC=1000
|
_________________ Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com |
|
Back to top |
|
|
ZY24 Beginner
Joined: 29 Mar 2007 Posts: 6 Topics: 2 Location: Birmingham, Alabama
|
Posted: Thu Mar 29, 2007 12:06 pm Post subject: Success |
|
|
Worked like a charm.
Thanks |
|
Back to top |
|
|
|
|