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
 
[Solved]compound conditions possible in OMIT?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
ranga_subham

New User


Joined: 01 Jul 2005
Posts: 51

PostPosted: Sat Jul 16, 2005 3:25 pm    Post subject: compound conditions possible in OMIT?
Reply with quote

Hi,

I have some input data as followed:

IN01AAAAAAAA6868AOBOCO
IN02BBBAAAAA1111AOBOCO
IN01ABABABAB6868AOBOCO
IN03BABABABA4678AOBOCO
IN02BABABABA6868AOBOCO
IN02BABABBBA6868AOBOCO
IN03AAAABBBA9878AOBOCO
IN01ABABABAB2222AOBOCO
IN01BBBBBBBB1212AOBOCO

Now, I want omit all those records that have 02 in 3rd & 4th column and 6868 in 13th to 16th column. Also, I want to omit all the records that have 01 in 3rd and 4th column. Please let me know how the SORT card will look like.

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

rssomm

New User


Joined: 05 Jun 2005
Posts: 41
Location: Hyderabad

PostPosted: Sat Jul 16, 2005 5:14 pm    Post subject:
Reply with quote

Please try following code.
Omit Cond=(2,2,ch,eq,c'02',and,13,4,ch,eq,c'6868',or,2,2,ch,eq,c'01')

Madhu..
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: Sat Jul 16, 2005 8:55 pm    Post subject:
Reply with quote

If your requirements can be written this way:

"I want to omit all of the records that have 02 in 3rd & 4th column and 6868 in 13th to 16th column, or that have 01 in 3rd and 4th column."

then you can write the corresponding DFSORT OMIT statement like this:

Code:

  OMIT FORMAT=CH,
     COND=((3,2,EQ,C'02',AND,13,4,EQ,C'6868'),OR,3,2,EQ,C'01')


The output records would be:

Code:

IN02BBBAAAAA1111AOBOCO
IN03BABABABA4678AOBOCO
IN03AAAABBBA9878AOBOCO
Back to top
View user's profile Send private message
ranga_subham

New User


Joined: 01 Jul 2005
Posts: 51

PostPosted: Tue Jul 19, 2005 4:44 pm    Post subject: Re: compound conditions possible in OMIT?
Reply with quote

Thank you Frank.
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 Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts RFE: Additional compound operators fo... prino PL/I & Assembler 1 Wed Jun 08, 2016 3:31 pm
No new posts Join and Omit records- Master File no... shajeeth DFSORT/ICETOOL 5 Tue Jan 26, 2016 8:16 pm
No new posts DFSORT report with multiple conditions Bill Woodger DFSORT/ICETOOL 9 Wed Jan 20, 2016 2:19 am

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