IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Maximum number of COND parameters in a SYNCSORT utitlity.


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 1306
Location: Vilnius, Lithuania

PostPosted: Thu May 12, 2011 4:58 pm
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
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: 1306
Location: Vilnius, Lithuania

PostPosted: Thu May 12, 2011 5:10 pm
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
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: 2481
Location: @my desk

PostPosted: Fri May 13, 2011 12:42 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Substring number between 2 characters... DFSORT/ICETOOL 2
No new posts Generate random number from range of ... COBOL Programming 3
Search our Forums:

Back to Top