Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Multiple SORT FIELDS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Sumeendar

New User


Joined: 31 Jan 2006
Posts: 39

PostPosted: Tue Aug 05, 2014 7:17 pm    Post subject: Multiple SORT FIELDS
Reply with quote

Can we use multipile SORT FIELDS in a single SORT CARD based on INCLUDE Condition.

The reason i am asking is because, i have a file wherein i need to sort certain records using different key fields, and remaining records in another set of key fields.

Is this possible. I tried using INCLUDE condition, but it didn't work

Thanks
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Tue Aug 05, 2014 7:42 pm    Post subject: Reply to: Multiple SORT FIELDS
Reply with quote

You want different parts of the same file sorted independently in one step? Yes, it can be done. If you thought INCLUDE would help, perhaps you can either explain how, or you can review what INCLUDE does in the documentation.

How you do it is extend your record by the longest value you want to SORT on. Conditionally put the correct data for the correct record into the key field. You do this in INREC, and then you SORT. In OUTREC or OUTFIL you return the record to its original size using BUILD.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Build Dynamic Sort output and limit '... balaji81_k DFSORT/ICETOOL 1 Sat Feb 02, 2019 4:40 am
This topic is locked: you cannot edit posts or make replies. PARAMETER 'F1' IS UNIDENTIFIED error ... Poha Eater DFSORT/ICETOOL 14 Fri Feb 01, 2019 2:39 pm
No new posts SORT INNER JOIN [F1] OUT OF SEQ ERROR balaji81_k DFSORT/ICETOOL 8 Wed Jan 30, 2019 3:21 am
No new posts Dates compare on specific dates using... balaji81_k DFSORT/ICETOOL 2 Thu Jan 24, 2019 12:03 am
No new posts Query on summing up the fields abdulrafi DFSORT/ICETOOL 10 Mon Jan 21, 2019 7:18 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us