Help Reqd( Binary Packed Decimal )

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Inquisitive
Charter Member
Charter Member
Posts: 88
Joined: Tue Jan 13, 2004 3:07 pm

Help Reqd( Binary Packed Decimal )

Post by Inquisitive »

Would Datastage process files containing fields with Binary Packed Decimal data? The file type can be Mainframe extracts or CSV Files.
Klaus Schaefer
Participant
Posts: 94
Joined: Wed May 08, 2002 8:44 am
Location: Germany
Contact:

Post by Klaus Schaefer »

Yes, that's no problem for datastage. You can either use the CFF stage or apply the DATATYPEPICCOMP3xxx transforms coming with the sdk. In both cases, be sure to have the original mainframe ebcdic data (must be ftp'ed in binary mode down to your server!).

Klaus
Inquisitive
Charter Member
Charter Member
Posts: 88
Joined: Tue Jan 13, 2004 3:07 pm

Help Reqd(Packed Binary Decimals)

Post by Inquisitive »

How do we go about using these routines (DATATYPEPICCOMP3xxx )?
Is it possible to use it with parallel jobs? or only with server jobs ?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You have access to these routines from parallel jobs if you use the "BASIC Transformer" stage (not the Transformer stage).
Search the Forum for "BASIC Transformer stage" if you're having trouble finding it in Designer.
This post should help; about half way down there's how to find the stage in the Processing group.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply