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

How can i omit the low value using DFSORT


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

New User


Joined: 21 Jun 2006
Posts: 5

PostPosted: Wed May 30, 2007 12:37 pm
Reply with quote

hi there,

my input file contain low value. How can i omit the low value using
dfsort. i had tried to use such below, but its not work..d input file contains only zd record.

OMIT=(01,16,CH,EQ,C' '), or
OMIT=(01,16,CH,EQ,C'0000 '),


please help icon_rolleyes.gif
Back to top
View user's profile Send private message
saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Wed May 30, 2007 12:50 pm
Reply with quote

Hi

Use the Below Sort Card

Quote:
input file contains only zd record


Code:

  OMIT COND=(1,16,ZD,EQ,0)


Thanks
Sai
Back to top
View user's profile Send private message
ladieheartz

New User


Joined: 21 Jun 2006
Posts: 5

PostPosted: Wed May 30, 2007 1:10 pm
Reply with quote

hi Sai,
thanx but its not work...syntax error, is there any way ?
Back to top
View user's profile Send private message
ladieheartz

New User


Joined: 21 Jun 2006
Posts: 5

PostPosted: Wed May 30, 2007 1:27 pm
Reply with quote

hi,

nvm..i've found d solution, coz the low value data is the first record so i just do like this :

OUTFIL FILES=1,STARTREC=2,

icon_wink.gif
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: Wed May 30, 2007 7:43 pm
Reply with quote

Quote:
but its not work...syntax error


Code:

  OMIT COND=(1,16,ZD,EQ,0)


is correct. If you got a syntax error, you probably didn't have a blank before OMIT.

If you want to skip the first record, you can do it more efficiently like this:

Code:

   OPTION SKIPREC=1
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 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
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
Search our Forums:

Back to Top