venat jella
New User
Joined: 19 Mar 2009 Posts: 1 Location: chennai
|
|
|
|
Hi All,
As i'm new to ICETOOL, I would like to sum up the amount individually(i.e. position 29-36) based upon the one Indicator(i.e. position 50) and display the same by using ICETOOL. Indicator will have the values of either Z or blank. If indicator is E, then i've to sum the charge amount of the input records which are having indicator as Z and same for blank also. In addition to that i've to display total amount irrespective of indicator.
I'm not able to create trailer records alone.
Current Code:
Code: |
INREC FIELDS=(C'A',29,8,71X)
SORT FIELDS=(1,1,CH,A)
OUTFIL FNAMES=OUTDDXX,REMOVECC,
NODETAIL,SECTIONS=(1,1,HEADER3=XX,
TRAILER3=(5:C'$',6:TOT=(2,8,SFF,
EDIT=(SIII,IIT.TT),SIGNS=(,-)),
2/,5:'---------------------------------------------------',
/,5:'---------------------------------------------------'))
|
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Please post some sample input and the output (including the trailer) you want from that input. Mention the "rules", the relevant data postiions, and the recfm and lrecl. |
|