Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 2285
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: 2285
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
No new posts query to fetch record which has only ... maxsubrat DB2 0 Mon Dec 11, 2017 5:03 pm
No new posts More than 1 Include criteria for sing... Roy Ware SYNCSORT 6 Wed Sep 13, 2017 11:45 pm
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm
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

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us