View previous topic :: View next topic
Author
Message
ramsri Active User Joined: 18 Oct 2008Posts: 380 Location: India
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
hikaps14 Active User Joined: 02 Sep 2005Posts: 189 Location: Noida
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
ramsri Active User Joined: 18 Oct 2008Posts: 380 Location: India
Kapil, sorry.....my mistake....
I was just researching the SS option.
Thanks.
Back to top
Arun Raj Moderator Joined: 17 Oct 2006Posts: 2481 Location: @my desk
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
ramsri Active User Joined: 18 Oct 2008Posts: 380 Location: India
Arun, thanks for the information......
Bad luck We are still at v1.2.
Back to top
Arun Raj Moderator Joined: 17 Oct 2006Posts: 2481 Location: @my desk
ramsri wrote:
Arun, thanks for the information......
Bad luck We are still at v1.2.
Me too..
Back to top
Please enable JavaScript!