How to change include cond sort from FILEAID TO ICEMAN



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

How to change include cond sort from FILEAID TO ICEMAN

Postby Danielle » Fri Aug 14, 2009 8:45 pm

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
Danielle
 
Posts: 8
Joined: Fri Aug 14, 2009 8:07 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby Frank Yaeger » Fri Aug 14, 2009 9:06 pm

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
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

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

Postby Danielle » Sat Aug 15, 2009 8:23 am

Thanks a lot for your help Mr Yaeger
I really appreciate your help
cheers
Danielle
Danielle
 
Posts: 8
Joined: Fri Aug 14, 2009 8:07 pm
Has thanked: 0 time
Been thanked: 0 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post