Neeed help in converting Packed decimals

[jojipjohn]

In my projects I am getting source files from Mainframe system in packed format. I am converting this using the tranformation "DataTypePicComp3()",but we are not getting correct values after conversion. Could anyone help me in this. Is there any other transformation for this.

Thanks for any help

[kumar_s]

If you were give the cobol layout, use Complex Flat File. It is worth to build a Cobol layout if not given.

[jojipjohn]

We are not given the the cobol layout.. we asked for the copy book but we will not get this......

Could you please tell me how to create a cobol layout... I read through the pdf for CFF but could not get a head and tail how to make the layout....

[madhukar]

If you dont have cobol layouts, then how you are reading the source files.

[dlkkrao]

Hi,

If you are using Sequential File as source, Then do the following steps.

Step1: Go to Format tab
Step2: Go to Type defaults
Step3: Go to Decimal
Step4: Select Packed=no(overpunch)
Step5: Select Sign position as trailing or leading depending upon ur requirement.

It converts the overpunch characters to decimal values.



Thanks
KKRao

[jojipjohn]

In the sequetial file stage I could not find the type defaults in the format tab.

Could you please explain this to me.

[balajisr]

In the sequetial file stage I could not find the type defaults in the format tab.

Could you please explain this to me.

Are you working in server or parallel jobs?

Type Defaults is not available in server jobs. It is available in parallel jobs. Your job type is server but you have posted in parallel forum.

[jojipjohn]

sorry I will post this in server jobs