Page 1 of 1

Help Reqd( Binary Packed Decimal )

Posted: Thu Apr 08, 2004 1:00 am
by Inquisitive
Would Datastage process files containing fields with Binary Packed Decimal data? The file type can be Mainframe extracts or CSV Files.

Posted: Thu Apr 08, 2004 3:12 am
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

Help Reqd(Packed Binary Decimals)

Posted: Wed Apr 14, 2004 12:55 am
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 ?

Posted: Wed Apr 14, 2004 1:33 am
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.