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
 

 

Problem with INCLUDE COND

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Problem with INCLUDE COND
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

Site Director


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

PostPosted: Sat Jan 29, 2011 10:07 am    Post subject:
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 Moderator


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

PostPosted: Tue Feb 01, 2011 2:13 am    Post subject:
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    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 Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm
No new posts Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am


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