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

Problem with INCLUDE COND


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
star_dhruv2000

New User


Joined: 03 Nov 2006
Posts: 87
Location: Plymouth, MN USA

PostPosted: Sat Jan 29, 2011 9:31 am
Reply with quote

Hi all,

I am surrounded by a unique problem in DFSORT. I am trying to locate few records based on conditions. There are 9M + records spread among 50+ files.

I had concatenated all 50+ DSN's and scanned through following SYSIN:

Code:

SORT FIELDS=COPY                           
INCLUDE COND=(23,6,CH,EQ,C' ---- ',OR,     
              44,7,CH,EQ,C'STARTED',OR,   
              44,5,CH,EQ,C'ENDED',OR,     
              35,5,CH,EQ,C'ENDED',OR,     
              6,10,CH,EQ,C'**** CYCLE',OR,
              38,5,CH,EQ,C'CYCLE')         


I am missing info. for
Code:
6,10,CH,EQ,C'**** CYCLE'


Apparently, When I run only
Code:
6,10,CH,EQ,C'**** CYCLE'
I get desired output. However, this is not populating any output with collective CONDs.

I ran few other tests:

1. Works Fine
Code:

SORT FIELDS=COPY                                               
INCLUDE COND=(6,10,CH,EQ,C'**** CYCLE',OR,23,6,CH,EQ,C' ---- ')


2. Fails
Code:

SORT FIELDS=COPY                                                 
INCLUDE COND=(6,10,CH,EQ,C'**** CYCLE',OR,23,6,CH,EQ,C' ---- ',OR,
              44,7,CH,EQ,C'STARTED')                             


3. Fails
Code:

SORT FIELDS=COPY                                               
INCLUDE COND=(6,10,CH,EQ,C'**** CYCLE',OR,44,7,CH,EQ,C'STARTED')
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat Jan 29, 2011 10:07 am
Reply with quote

Hello,

Suggest you create a test file with only 20 records or so that has at least one record that meets every condition. Make sure there is at least one record that does not meet any of the conditions. Submit the job and post the output file and the informational messages generated including all of the message id's.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Tue Feb 01, 2011 2:13 am
Reply with quote

What is the RECFM and LRECL of your input files?

What you're saying does not make sense, so there has to be something you aren't telling us about your data or job.

Quote:
2. Fails


By fails, do you mean it doesn't include the output records you expect, or do you mean it issues an error message?

Please do what Dick suggests - make up a small set of input data that shows the problem and post that data along with the complete set of JES messages.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts z/vm installation problem All Other Mainframe Topics 0
No new posts Reference for COND parameter. JCL & VSAM 1
No new posts Job scheduling problem. JCL & VSAM 9
Search our Forums:

Back to Top