Converting a binary field into a packed decimal

sthirumalai · New User Joined: 14 Aug 2007 Posts: 14 Location: Chennai

Hi

I have a field which is 9(8) COMP staring from the position 24 in a flat file.

I want to convert that into a packed decimal value S9(15)V9(03) COMP-3 and write the value staring from 73 rd position in my output file.

I used the following statemeny in my sortcard

73:24,4,BI,TO=PD,LENGTH=10,

But the values converted are incorrect.

For eg:

If the 9(8) COMP value is 400 then i received 0.400 in my output file after conversion. But the result must be 400.000 in my output.

Can any one help me to fix this issue?

Thanks & Regards
Santhosh

dbzTHEdinosauer · Posted: Fri Jul 01, 2011 2:03 am

Skolusu · Posted: Fri Jul 01, 2011 2:42 am

sthirumalai,

comp fields does not have decimals. so if your intention is to take an absolute value and pad with 3 decimals then you need to multiply it with 1000 and convert it to pd format. Also use FI instead of BI so that you can account for negative numbers also.

Use the following control cards