Page 1 of 1

ICETOOL report amount not showing sign correctly

PostPosted: Tue Jul 31, 2012 9:46 pm
by GRAMBO
I have an input file with the following amounts in position 114, 16 -
-000000000000832
000000000000832
-000000000000867
000000000000867
-000000000000868
000000000000868
-000000000001222
000000000001222

And am trying to create a report using Icetool where I want the amounts to appear on the report with the relevant sign, so I can then show a total at the bottom. for example something like -
AMOUNT
--------
-8.32
8.32
-8.67
8.67
-8.68
8.68
Total 0.00

However, I cannot get the sign to appear at all, all I get is -
AMOUNT
---------
8.32
8.32
8.67
8.67
8.68
8.68
Total 51.34

I've tried several edit masks - here's the JCL I am using ??
    //STEP20   EXEC PGM=ICETOOL,COND=(0,NE)                               
    //TOOLMSG  DD SYSOUT=*                                               
    //DFSMSG   DD SYSOUT=*                                               
    //SETTLOJ  DD DSN=Input,       
    //SETTREP  DD DSN=output,       
    //         DISP=(,CATLG,DELETE),                                     
    //         SPACE=(CYL,(100,100),RLSE),                               
    //         DCB=(BLKSIZE=0,RECFM=FB,LRECL=250)                         
    //TOOLIN   DD *                                                       
       DISPLAY FROM(SETTLOJ) LIST(SETTREP) LINES(50)       -             
       TITLE('TITLE') -       
       DATE(DM4/) TIME PAGE                                -             
       HEADER('AMOUNT')                 ON(114,16,ZD,C1,N16)   -         
       TOTAL('TOTAL AMOUNT')                                             



Thank you!!

Re: ICETOOL report amount not showing sign correctly

PostPosted: Tue Jul 31, 2012 9:55 pm
by BillyBoyo
You have said the field is ZD, but it isn't. You have a Signed Free Format field, so try changing the ZD to SFF for amount. Check in the manual on the field-types available, and read-up on ZD and SFF and their siblings. You don't have to read on all, just know what's there and where to look next time.

Re: ICETOOL report amount not showing sign correctly

PostPosted: Tue Jul 31, 2012 10:03 pm
by skolusu
As Bill, mentioned your input is not ZD , it is SFF(Signed Free Format field) , change the format to SFF instead of ZD and you will get the desired results.