DSXchange

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 ??

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.

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.