MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

DFSORT include/Omit cond Question

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
gans79
Beginner


Joined: 31 Aug 2005
Posts: 51
Topics: 27

PostPosted: Wed Oct 26, 2005 3:56 am    Post subject: DFSORT include/Omit cond Question Reply with quote

hi ,
if i use INCLUDE COND & OMIT COND in the optons it is giving a error as
duplicate COND , how do i resolve this.
Code:

//SYSIN    DD *                                                   
  SORT FIELDS=(27,4,PD,A)
  SUM FIELDS=NONE                                                 
  OMIT COND=(31,5,PD,LT,20050320)         
  INCLUDE COND=(47,4,ZD,EQ,0671)
  OUTFIL FNAMES=CATEG,                     
//*

thanks
ganesh
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Wed Oct 26, 2005 4:05 am    Post subject: Reply with quote

gans79,

Try this control cards

Code:

//SYSIN DD *
  INCLUDE COND=(47,4,ZD,EQ,0671)
  SORT FIELDS=(27,4,PD,A) 
  SUM FIELDS=NONE
  OUTFIL FNAMES=CATEG,OMIT=(31,5,PD,LT,20050320) 
/*


Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
gans79
Beginner


Joined: 31 Aug 2005
Posts: 51
Topics: 27

PostPosted: Wed Oct 26, 2005 4:19 am    Post subject: Reply with quote

hi kolusu, Smile
your method worked, but i didn't understand why my method did not work, can u give me some info regarding it and also, can i use mutiple oufil with different omit cond :
Code:

//SYSIN DD *
  INCLUDE COND=(47,4,ZD,EQ,0671)
  SORT FIELDS=(27,4,PD,A) 
  SUM FIELDS=NONE
  OUTFIL FNAMES=CATEG,OMIT=(31,5,PD,LT,20050320)
  OUTFIL FNAMES=CATEG2,OMIT=(31,5,PD,LT,20050321) 
  OUTFIL FNAMES=CATEG3,OMIT=(31,5,PD,LT,20050322) 
 
/*


thanks
ganesh
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Wed Oct 26, 2005 4:24 am    Post subject: Reply with quote

gans79,

Yes you can use multiple OMIT/INCLUDE conditions. check this link which will explain the DFSORT processing flow

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/1.5.4?DT=20050222160456

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Wed Oct 26, 2005 10:49 am    Post subject: Reply with quote

Quote:
i didn't understand why my method did not work, can u give me some info regarding it and also, can i use mutiple oufil with different omit cond


You can use one INCLUDE or OMIT statement. The INCLUDE or OMIT statement is processed before the SORT statement. You can use one or more OUTFIL statements, each of which can have one INCLUDE or OMIT operand. The OUTFIL statements are processed after the SORT statement.

Your "method" didn't work because you had both an INCLUDE and an OMIT statement, and only one is allowed. Also, you had:

Code:

  OUTFIL FNAMES=CATEG,


which is a syntax error because the comma at the end tells DFSORT to expect another parameter and you don't have one.

Kolusu corrected your syntax and used an INCLUDE statement, and an OUTFIL statement with an OMIT parameter, which is allowed.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group