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
 

 

Maximum number of COND parameters in a SYNCSORT utitlity.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
GaneshMF

New User


Joined: 19 Jun 2009
Posts: 27
Location: Chennai

PostPosted: Thu May 12, 2011 4:55 pm    Post subject: Maximum number of COND parameters in a SYNCSORT utitlity.
Reply with quote

Hi,

I have to run a SORT JCL to copy few lines from a file based on conditions. I have around 1500 conditions to be checked and the line can be copied from input file to outfile even if a single condition (out of 1500) is satisfied. I used the below code to accomplish it, but the job abended with U041.

SORT FIELDS=COPY
INCLUDE COND=((133,5,CH,EQ,C'ABCDD'),OR,
(133,5,CH,EQ,C'KSIKD'),OR,
(133,5,CH,EQ,C'KDIKE'),OR,
(133,5,CH,EQ,C'KEIEU'),OR,
(133,5,CH,EQ,C'34001'),OR,
(133,5,CH,EQ,C'90432'),OR,
....
....
....
....))

But if I reduce the number of conditions specified to 600 numbers the job completes fine. Is there any way to accomplish it by using all the 1500 conditions?
Back to top
View user's profile Send private message

prino

Senior Member


Joined: 07 Feb 2009
Posts: 1002
Location: Oostende, Belgium

PostPosted: Thu May 12, 2011 4:58 pm    Post subject:
Reply with quote

Run it in three parts.
Back to top
View user's profile Send private message
GaneshMF

New User


Joined: 19 Jun 2009
Posts: 27
Location: Chennai

PostPosted: Thu May 12, 2011 5:02 pm    Post subject: Reply to: Maximum number of COND parameters in a SYNCSORT ut
Reply with quote

Is there no other way to complete it in a single SORT job??
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1002
Location: Oostende, Belgium

PostPosted: Thu May 12, 2011 5:10 pm    Post subject:
Reply with quote

A single job?

Ask SyncSort to remove this restriction and be prepared to fork out sithloads of dosh!
Back to top
View user's profile Send private message
GaneshMF

New User


Joined: 19 Jun 2009
Posts: 27
Location: Chennai

PostPosted: Thu May 12, 2011 5:14 pm    Post subject: Reply to: Maximum number of COND parameters in a SYNCSORT ut
Reply with quote

Sorry, I meant in a single step...
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2237
Location: @my desk

PostPosted: Fri May 13, 2011 12:42 am    Post subject:
Reply with quote

A Join application with one file having all the unique values you want to check for, should do it.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts GDG version number PANDU1 JCL & VSAM 4 Sat Mar 04, 2017 8:28 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am


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