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
 

 

How can i omit the low value using DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: How can i omit the low value using DFSORT
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    Post subject:
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    Post subject:
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    Post subject:
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 Moderator


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

PostPosted: Wed May 30, 2007 7:43 pm    Post subject:
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    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 How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts DFSORT sorting only specific records akodakka DFSORT/ICETOOL 4 Thu Aug 04, 2016 11:24 am
No new posts Symbolic Parameters in SYSIN DD state... madishpa DFSORT/ICETOOL 3 Mon Jun 27, 2016 6:23 pm
No new posts DFSORT to match two files and write John F Dutcher DFSORT/ICETOOL 6 Thu May 12, 2016 5:17 pm


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