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 cards in sort include

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

New User


Joined: 26 Feb 2004
Posts: 19
Location: Chennai

PostPosted: Wed May 25, 2005 4:15 pm    Post subject: Maximum cards in sort include
Reply with quote

Hi
Could anyone help us on the maximum cards that can be coded inside an
Sort Include cond?

Eg:
Sort fields=copy
include cond=(1,2,ch,c'a1',or,
1,2,ch,c'a2',or,
.
.
.
1,2,ch,c'an')


I have some 2500 values to be given in include cond. the job abends with a message "EXCESS CARDS".

please help me ASAP.
Thanks in advance.
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed May 25, 2005 9:10 pm    Post subject:
Reply with quote

This would work fine with DFSORT. With DFSORT, you can use about 2700 such conditions in an INCLUDE statement. (And you can use DFSORT's IFTHEN function along with OUTFIL INCLUDE to handle a much larger number of conditions.) Note that there's virtually no limit to the number of "cards" you can use with DFSORT.

However, the "EXCESS CARDS" message indicates you're using Syncsort, not DFSORT, so I can't help you.
Back to top
View user's profile Send private message
sasi.palani

New User


Joined: 01 Jun 2005
Posts: 14

PostPosted: Sat Jun 11, 2005 11:49 am    Post subject:
Reply with quote

hai in an ordinary sort card u can use a maximum of 8 cond


go for dfsort or syncsort.


rgds
shashi
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Sat Jun 11, 2005 8:08 pm    Post subject:
Reply with quote

sasi.palani wrote:
hai in an ordinary sort card u can use a maximum of 8 cond

go for dfsort or syncsort.

rgds
shashi


Where did you get the idea that the maximum is 8 conditions? As I said in my earlier post, DFSORT can handle thousands of conditions. Please don't post incorrect information!
Back to top
View user's profile Send private message
achittu

New User


Joined: 26 Feb 2007
Posts: 14
Location: chennai

PostPosted: Mon Oct 22, 2007 3:26 pm    Post subject: Maximum cards in sort include
Reply with quote

Frank,

I have a very similar requirement.. I am trying to sort using more than 6000 INCLUDE conditions. I have used IFTHEN clause , I get the message ICE151A 1 TOO MANY *INREC IFTHEN 1 CONDITIONS .

How to overcome this problem ?


The following is my sort card :

OPTION COPY
INREC IFTHEN=(WHEN=((3,2,CH,EQ,C'00',OR,
3,2,CH,EQ,C'76',OR,
3,2,CH,EQ,C'71',OR,
3,2,CH,EQ,C'87'),AND,
(891,6,CH,EQ,C'705437',OR,
891,6,CH,EQ,C'710232',OR,
891,6,CH,EQ,C'708538',OR,
repeated 6000 times
) ,
BUILD=(C'TOPT',5:923,7,PD,19:849,9,ZD,
C'M',30:1,5609,4000X,4000X,3862X))

The input file is FB with LRECL = 17,500
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Oct 22, 2007 9:20 pm    Post subject:
Reply with quote

You can get use just over 2000 conditions of the form p,6,CH,EQ,C'string', so you'll need to break up your INREC into multiple IFTHENs using the technique shown in the Programmer Response for message ICE151A:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CM20/2.2.147?SHELF=&DT=20060721170811&CASE=

Alternatively, depending on what exactly you're trying to do, you might be able to do it using the matching functions of DFSORT/ICETOOL's SELECT or SPLICE operator.
Back to top
View user's profile Send private message
achittu

New User


Joined: 26 Feb 2007
Posts: 14
Location: chennai

PostPosted: Mon Oct 22, 2007 10:31 pm    Post subject:
Reply with quote

Thanks Frank,

Yours was a wonderful solution. It is working for us.

We used to do it using SPLICE earlier but realized that SPLICE was taking time for two reasons - we need to copy the input file to an intermediate dataset ( ours is a huge input file) and moreover SPLICE interanlly sorts the records but actually we dont need to sort the file , we just need to filter them based on the policy list. So we decided to opt for having the condtions coded in the parm.
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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm


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