Converting Packed Decimal value to decimal value

Kapil · Post by **Kapil** » Wed Mar 29, 2006 3:05 am

Hi,

I am working on Datstage TX 8.0. I have an input where in the values (amount) are in Packed Decimal format. The input will be coming in the following format S9(14) or 8 bytes. I want to transform them into decimal values. Could you please help me ??

dlkkrao · Post by **dlkkrao** » Wed Mar 29, 2006 6:03 am

Hi Kapil,

Check the property packed in decimal category in Type defaults in Format tab of a sequential file stage. Set the value as no(overpunch) or no(zoned) or no(separate) depending upon your requirement.

Thanks,
Rohit.

rodneycrowe · Post by **rodneycrowe** » Thu Mar 30, 2006 11:16 am

Actually, why not use the UNPACK() function in a map rule to convert the data. I am not sure what the other person is talking aboutbut is does not seem to be TX.