MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

LIMITING recs and SORTING in one step

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
ZY24
Beginner


Joined: 29 Mar 2007
Posts: 6
Topics: 2
Location: Birmingham, Alabama

PostPosted: Thu Mar 29, 2007 10:48 am    Post subject: LIMITING recs and SORTING in one step Reply with quote

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
View user's profile Send private message Send e-mail
amargulies
Beginner


Joined: 10 Jan 2007
Posts: 123
Topics: 0

PostPosted: Thu Mar 29, 2007 10:56 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
ZY24
Beginner


Joined: 29 Mar 2007
Posts: 6
Topics: 2
Location: Birmingham, Alabama

PostPosted: Thu Mar 29, 2007 12:06 pm    Post subject: Success Reply with quote

Worked like a charm.

Thanks
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group