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

[Solved]compound conditions possible in OMIT?


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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
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 Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Sat Jul 16, 2005 8:55 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts How to load to DB2 with column level ... DB2 6
No new posts Use input file with OMIT rcd keys? DFSORT/ICETOOL 15
No new posts Db2 SQL - how to switch among differe... DB2 18
No new posts To search DB2 table based on Conditio... DB2 1
Search our Forums:

Back to Top