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
 

 

Include COND with SS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Mon Dec 15, 2008 3:21 pm    Post subject: Include COND with SS
Reply with quote

Hi,

Using INCLUDE COND we can copy only those records that meet criteria. If we have to look for different values starting at same column we generally code like this.....

Code:

INCLUDE COND=(1,4,CH,EQ,C'1234',OR,1,4,CH,EQ,C'2345')

OR

INCLUDE COND=(1,4,SS,EQ,C'1234,2345')


How to code and AND condition in the same way while using SS option with INCLUDE?

Thanks.
Back to top
View user's profile Send private message

hikaps14

Active User


Joined: 02 Sep 2005
Posts: 189
Location: Noida

PostPosted: Mon Dec 15, 2008 4:29 pm    Post subject: Reply to: Include COND with SS
Reply with quote

Hi,

You gave SS code for below include cond :

Code:
INCLUDE COND=(1,4,CH,EQ,C'1234',OR,1,4,CH,EQ,C'2345')


If I am not mistaken you are looking for something

Code:
INCLUDE COND=(1,4,CH,EQ,C'1234',AND,1,4,CH,EQ,C'2345')


I want you to ask one thing. How is it possible to find two different string in the same record at the same field.

Is the AND condition valid, will it give you any records ?

Were you really using this condition or you were just researching on SS.

Thanks,
-Kapil.
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Mon Dec 15, 2008 4:39 pm    Post subject: Reply to: Include COND with SS
Reply with quote

Kapil, sorry.....my mistake.... icon_redface.gif

I was just researching the SS option.

Thanks.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2181
Location: @my desk

PostPosted: Mon Dec 15, 2008 6:55 pm    Post subject:
Reply with quote

Ramsri,

If you have Syncsort for z/OS Release 1.3 you can simplify your EQ/OR and NE/AND conditions like this,

EQ/OR
Code:
INCLUDE COND=(1,1,CH,EQ,C'X',OR,
              1,1,CH,EQ,C'Y',OR,
              1,1,CH,EQ,C'Z')
Code:
INCLUDE COND=(1,1,CH,EQ,L(C'X',C'Y',C'Z'))


NE/AND
Code:
INCLUDE COND=(1,1,CH,NE,C'P',AND,
              1,1,CH,NE,C'Q',AND,
              1,1,CH,NE,C'R')
Code:
INCLUDE COND=(1,1,CH,NE,L(C'P',C'Q',C'R'))
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Tue Dec 16, 2008 1:32 am    Post subject: Reply to: Include COND with SS
Reply with quote

Arun, thanks for the information......

Bad luck icon_sad.gif We are still at v1.2.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2181
Location: @my desk

PostPosted: Tue Dec 16, 2008 8:06 am    Post subject: Re: Reply to: Include COND with SS
Reply with quote

ramsri wrote:
Arun, thanks for the information......

Bad luck icon_sad.gif We are still at v1.2.
Me too.. icon_sad.gif
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
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 how to DYNAMICALLY write sort cond to... mohamedmubee COBOL Programming 13 Fri Aug 26, 2016 11:46 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts COND parameter vs IF THEN ELSE Alks JCL & VSAM 11 Fri Jun 17, 2016 5:28 pm
No new posts Include Cond issue vickey_dw DFSORT/ICETOOL 6 Tue Mar 29, 2016 8:51 pm


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