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

Need help on sort


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

New User


Joined: 20 Nov 2008
Posts: 9
Location: Delhi

PostPosted: Thu Feb 20, 2014 5:50 pm
Reply with quote

I need to copy the records is cols 13-14 and 33-24 has value 00.
records in input file as -

0514XX24173202 0514XX24173201

I have tried with but it copied all records in output file.

//SYSIN DD *
SORT FIELDS=COPY
INREC IFTHEN=(WHEN=(13,2,CH,EQ,C'00',AND,33,2,CH,EQ,C'00'),
BUILD=(1,40))

Could you please help on this?

Thanks!
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Thu Feb 20, 2014 5:52 pm
Reply with quote

Look at INCLUDE/OMIT COND=
Back to top
View user's profile Send private message
rajkumarprajapati

New User


Joined: 20 Nov 2008
Posts: 9
Location: Delhi

PostPosted: Thu Feb 20, 2014 5:57 pm
Reply with quote

yes, it is working correctly..

SORT FIELDS=COPY
INCLUDE COND=(13,2,CH,EQ,C'00',AND,33,2,CH,EQ,C'00')


Thanks for point out mistake
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 How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
Search our Forums:

Back to Top