Page 1 of 1
Neeed help in converting Packed decimals
Posted: Tue Aug 08, 2006 3:10 am
by 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
Posted: Tue Aug 08, 2006 3:14 am
by kumar_s
If you were give the cobol layout, use Complex Flat File. It is worth to build a Cobol layout if not given.
Posted: Tue Aug 08, 2006 3:20 am
by 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....
Posted: Tue Aug 08, 2006 3:31 am
by madhukar
If you dont have cobol layouts, then how you are reading the source files.
Posted: Tue Aug 08, 2006 3:53 am
by 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
Posted: Tue Aug 08, 2006 4:06 am
by jojipjohn
In the sequetial file stage I could not find the type defaults in the format tab.
Could you please explain this to me.
Posted: Tue Aug 08, 2006 4:16 am
by balajisr
jojipjohn wrote: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.
Posted: Tue Aug 08, 2006 4:53 am
by jojipjohn
sorry I will post this in server jobs