ICETOOL report amount not showing sign correctly



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

ICETOOL report amount not showing sign correctly

Postby GRAMBO » Tue Jul 31, 2012 9:46 pm

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!!
GRAMBO
 
Posts: 8
Joined: Fri Oct 15, 2010 10:22 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL report amount not showing sign correctly

 

Re: ICETOOL report amount not showing sign correctly

Postby BillyBoyo » Tue Jul 31, 2012 9:55 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: ICETOOL report amount not showing sign correctly

Postby skolusu » Tue Jul 31, 2012 10:03 pm

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.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post