Page 1 of 1

Read Packed Decimal from EBCDIC File

Posted: Tue Jan 11, 2011 7:49 pm
by natesan81DS
I am new to DS and need your assistance on the below.
I am receiving a EBCDIC file from Mainframe, which has the Start position and Length of a particular String. The string is in Packed decimal format. My requirement is to read the start position and Length, and with the help of Start position and Length read the packed decimal string.

Please help me out with your expertise. Thanks.

Posted: Tue Jan 11, 2011 10:55 pm
by ray.wurlod
Welcome aboard. Are you using a Complex Flat File stage? This has inbuilt support for packed decimal data.

Posted: Tue Jan 11, 2011 11:21 pm
by natesan81DS
ray.wurlod wrote:Welcome aboard. Are you using a Complex Flat File stage? This has inbuilt support for packed decimal data. ...
@Ray - Thanks for your quick response

Yes. I tried using a CFF Stage.

I have a Character field in my file from which i need to read a substring (which is of packed decimal format).

Since I have the Packed Decimal within the Character field, I could see JUNK Values while usign the CFF Stage.