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

Can i use AND in include statement of DFSORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
nivethitha_kumar

New User


Joined: 24 Jan 2007
Posts: 11
Location: chennai

PostPosted: Fri Feb 16, 2007 7:27 pm
Reply with quote

can i use AND or OR in include to have two conditions

e.g

Code:

  OUTFIL FNAMES=OUT01,INCLUDE=(12,2,CH,EQ,C'12',AND,12,2,CH,EQ,C'11'),BUILD=(1,10)


What if i want the two conditions to be satisfied or one of them to write in to the file. i dont want to use too many temp files.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Fri Feb 16, 2007 7:58 pm
Reply with quote

You can use multple ANDs and ORs.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Fri Feb 16, 2007 8:18 pm
Reply with quote

nivethitha_kumar wrote:
COND=(12,2,CH,EQ,C'11',AND,12,2,CH,EQ,C'22')
How can 12,2 = C'11" and at the same time = C'22'? icon_confused.gif
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Feb 16, 2007 8:36 pm
Reply with quote

It should at least be
Code:

  OUTFIL FNAMES=OUT02,
    INCLUDE=(12,2,CH,EQ,C'11',OR,12,2,CH,EQ,C'22'),BUILD=(1,10)
Back to top
View user's profile Send private message
nivethitha_kumar

New User


Joined: 24 Jan 2007
Posts: 11
Location: chennai

PostPosted: Sat Feb 17, 2007 10:08 am
Reply with quote

oops i am sorry abt tht... but i was getting a syntax error on COND...The prev syntax by superk worked though... thanks
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 Feb 17, 2007 10:00 pm
Reply with quote

To clear things up as to syntax:

COND is used with the INCLUDE or OMIT statement, e.g.

Code:

   INCLUDE COND=(...)


INCLUDE or OMIT are used with the OUTFIL statement:

Code:

   OUTFIL INCLUDE=(...)
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 DFSORT GUID DFSORT/ICETOOL 2
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
Search our Forums:

Back to Top