Variable Length in ICETOOL



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Variable Length in ICETOOL

Postby fornanthakumar » Tue Jan 17, 2012 3:19 pm

Hi,

I am using ICETOOL to get the trailer sum up records for my project. It does have header and trailer. Hence this file consider as variable length record with three different layout for header (33 length), trailer and transaction record respectively.

My SORT card like,
SORT FIELDS=(58,4,CH,A,63,3,CH,A,67,16,ZD,A,84,4,CH,A)
OUTFIL REMOVECC,
SECTIONS=(58,4,63,3,67,16,84,4,
TRAILER3=(5,26,TOT=(31,8,PD,TO=PD,LENGTH=8),39,190,C'T'))

While executing this utility , i got an error
"ICE218A 0 37 BYTE VARIABLE RECORD IS SHORTER THAN 87 BYTE MINIMUM FOR " because of variable length..

OPTION VLSHRT/VLSCMP are not working in ICETOOL..

Please somebody help me out on this...
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 70
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Variable Length in ICETOOL

 

Re: Variable Length in ICETOOL

Postby BillyBoyo » Tue Jan 17, 2012 4:44 pm

Can you be more exact about your processing please, with a sample from your input dataset and the expected output for that sample. If you have headers and trailers on your input, how do you want them to appear on your output?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Variable Length in ICETOOL

Postby Frank Yaeger » Tue Jan 17, 2012 11:33 pm

fornanthakumar,

Since you didn't show your complete job or JES log,it's difficult to know exactly what you're doing (you mention ICETOOL but you aren't showing any ICETOOL JCL).

The ICE218A refers to a minimum of 87 bytes which would correspond to your 84,4,CH,A sort field. VLSHRT would take care of that, so perhaps you aren't coding it in the correct way. Wherever you have these control statements:

  SORT FIELDS=(58,4,CH,A,63,3,CH,A,67,16,ZD,A,84,4,CH,A)
  OUTFIL REMOVECC,
    SECTIONS=(58,4,63,3,67,16,84,4,
   TRAILER3=(5,26,TOT=(31,8,PD,TO=PD,LENGTH=8),39,190,C'T'))


add OPTION VLSHRT to them like this:

  OPTION VLSHRT
  SORT FIELDS=(58,4,CH,A,63,3,CH,A,67,16,ZD,A,84,4,CH,A)
  OUTFIL REMOVECC,
    SECTIONS=(58,4,63,3,67,16,84,4,
   TRAILER3=(5,26,TOT=(31,8,PD,TO=PD,LENGTH=8),39,190,C'T'))


If that doesn't work then show your complete JES log for the failing run. Also, tell me the RECFM and LRECL of your input file.
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: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post