Signed Decimal summation & Conversion to Zonal Decimal

manoz_k · New User Joined: 08 Mar 2007 Posts: 23 Location: CHENNAI

Hi,

Here is my requirement :

Part -1

I have input file with few Amount fileds in the following format 9(9).9(2)
I want to Sum fields in say columns 97 (spanned across 13 bytes 1 byte for sign, 9 for number fields, 1 byte for decima and 2 for Decimal )

-000000270.00+000000000.25
+000000210.00-000000000.25

Part -2

After summation of amount fields based on a Key ( suppose at 34 byte for 11 bytes ) i want to convert the output to ZONED Decimal format.

Thank you very much for your time.

Skolusu · Posted: Thu Jan 29, 2009 1:52 am

manoz_k,

Assuming that you want to sum the amount fileds based on the key in pos 97 for 13 bytes and in pos 110 for 13 bytes the following DFSORT control cards will give you the desired results.

Frank Yaeger · Posted: Thu Jan 29, 2009 2:12 am

Manoj,

If you want to convert the summed amounts to ZD format, you can change the TOT lines to:

manoz_k · New User Joined: 08 Mar 2007 Posts: 23 Location: CHENNAI

Frank Yaeger · Posted: Thu Jan 29, 2009 3:52 am

Your TRAILER length is greater than your input length which isn't allowed. You can avoid the error message by using a BUILD operand like so:

manoz_k · New User Joined: 08 Mar 2007 Posts: 23 Location: CHENNAI

I feel i got the expected output.What i see from the Trailer record is that embeds a space before the SIGN field for that i took additional 5 bytes.Actually my file is of 81 Bytes alone, but trailer record was expecting 86, as i have 5 amount fields so 5 Signs needed.Which took it to 86.

Thank you very much for your help !!!

manoz_k · New User Joined: 08 Mar 2007 Posts: 23 Location: CHENNAI

This helped me to put it in the Zoned Decimal format finally. Thanks a lot for your help.

manoz_k · New User Joined: 08 Mar 2007 Posts: 23 Location: CHENNAI

dick scherrer · Posted: Thu Jan 29, 2009 8:16 am

Hello,

Frank Yaeger · Posted: Thu Jan 29, 2009 9:37 pm

Manoj,

SFF will handle signed and unsigned input values.

TO=ZD will handle signed and unsigned totals. The sign will be F for positive values or D for negative values. You could use TO=ZDC if you want C for positive values.