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
 
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: 1102
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: 1102
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: 2353
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 Reformatting and adding additional fi... Badbeef SYNCSORT 6 Thu Apr 05, 2018 4:45 pm
No new posts Repeat Sequence Number Until change i... rahulabvp DFSORT/ICETOOL 6 Thu Mar 29, 2018 12:51 pm
No new posts add sequence number for duplicate rec... SRUTHI DRAVIDAMANI COBOL Programming 11 Thu Feb 22, 2018 5:37 pm
No new posts PARSE GDG name to separate generation... Abid Hasan SYNCSORT 2 Sun Feb 11, 2018 3:40 pm
No new posts Logic to skip Maximum time-stamp and ... vickey_dw DB2 2 Thu Feb 01, 2018 11:15 pm

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