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
Neeed help in converting Packed decimals
Moderators: chulett, rschirm, roy
Neeed help in converting Packed decimals
Joji John
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
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
Are you working in server or parallel jobs?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.
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.