Page 1 of 1

How to change include cond sort from FILEAID TO ICEMAN

PostPosted: Fri Aug 14, 2009 8:45 pm
by Danielle
Please help!!
Recently my company has change the sort tool to use ICEMAN but not FILEAID to do the sort (which include Pack field)
in FILEAID , the sysin was define as below

IF=(21,EQ,C'B,S,T'),
AND=(30,GT,P'+0'),
MOVE=(1,34,1),WRITE=FILE1

BUT to change to ICEMAN sort, I don't know how to write in the sysin
1) for OR and AND condition together IN THE SAME STEP
so I write them separately for each steps (ie first step cater for OR (b,s,t) it works )

2) but for 2ndstep I wrote in the sysin

SORT FIELDS =(1,20,CH,A)
INCLUDE COND=(30,5,CH,GT,P'+0')
OUTREC FILEDS=(1,34)

the system complain at position of P
INCLUDE COND=(30,5,CH,GT,P'+0')
$
comparison filed error

Q: how do I write in ICEMAN sort utility for the include cond if at position 30, it is a package decimal of 5 length must be greater than +0 ??
how do I write them both in 1 step ??

Thank you

Re: How to change include cond sort from FILEAID TO ICEMAN

PostPosted: Fri Aug 14, 2009 9:06 pm
by Frank Yaeger
The DFSORT INCLUDE statement would be:

   INCLUDE COND=(21,1,SS,EQ,C'B,S,T',AND,30,5,PD,GT,+0)


If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss? ... g3T7000080

Re: How to change include cond sort from FILEAID TO ICEMAN

PostPosted: Sat Aug 15, 2009 8:23 am
by Danielle
Thanks a lot for your help Mr Yaeger
I really appreciate your help
cheers
Danielle