Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can i use AND in include statement of DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Can i use AND in include statement of DFSORT
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: 3158
Location: Tucson AZ

PostPosted: Fri Feb 16, 2007 7:58 pm    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Fri Feb 16, 2007 8:18 pm    Post subject:
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

Moderator Team Head


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

PostPosted: Fri Feb 16, 2007 8:36 pm    Post subject: Re: can i use AND in include
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    Post subject:
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 Moderator


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

PostPosted: Sat Feb 17, 2007 10:00 pm    Post subject:
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    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 DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
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


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us