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

Include COND with SS


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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
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
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: 2481
Location: @my desk

PostPosted: Mon Dec 15, 2008 6:55 pm
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
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: 2481
Location: @my desk

PostPosted: Tue Dec 16, 2008 8:06 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Reference for COND parameter. JCL & VSAM 1
No new posts IEF142I and Cond. Code 12 All Other Mainframe Topics 3
No new posts Cond parameter and Rc code of a proce... JCL & VSAM 5
This topic is locked: you cannot edit posts or make replies. Sort to include records of file 2 int... Java & MQSeries 1
Search our Forums:

Back to Top