Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Using Sort and include cond in single step

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
rikdeb

New User


Joined: 19 Jan 2009
Posts: 59
Location: hyderabad

PostPosted: Tue Apr 08, 2014 5:47 pm    Post subject: Using Sort and include cond in single step
Reply with quote

Hi.. i was trying to split a file based on some conditions using INCLUDE statement like below.(I am using syncsort 1.4.0 )
Code:

OPTION COPY                                                         
OUTFIL FILES=01,INCLUDE=(80,3,CH,EQ,C'A01')
OUTFIL FILES=02,INCLUDE=(80,3,CH,NE,C'A01')

Till this point its fine and simple.
however I am trying to SORT the files based on some fields as well in one shot using SORT FIELDS=(24,10,CH,A) along with include conditions.
This is not the correct way ,so getting syntax error. Tried like below also
Code:

OUTFIL FILES=02               
SORT FIELDS=(24,10,CH,A)     
INCLUDE COND=(80,1,CH,EQ,C'A')
                             
OUTFIL FILES=01               
SORT FIELDS=(12,1,CH,A)       
INCLUDE COND=(80,1,CH,NE,C'A')


But getting DUPLICATE STATEMENT FOUND.
Could you please suggest any way...!
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7309

PostPosted: Tue Apr 08, 2014 6:18 pm    Post subject: Reply to: Using Sort and include cond in single step
Reply with quote

Because you have duplicate SORT statements.

You can only have one SORT in a single step.

You can do one SORT and do the split, and SORT in another step for the second file. Or, especially with a lot of records, you can create an extra key, populated depending on your selection, and SORT on that key, to get both orders at once.
Back to top
View user's profile Send private message
rikdeb

New User


Joined: 19 Jan 2009
Posts: 59
Location: hyderabad

PostPosted: Tue Apr 08, 2014 6:25 pm    Post subject: Reply to: Using Sort and include cond in single step
Reply with quote

Hi Bill.. Thanks for the clarification.!!.. Will do that...
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 -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 4 Mon Mar 27, 2017 3:59 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us