Page 1 of 1
Posted: Fri Nov 21, 2008 12:51 pm
by ratikmishra1
Can you use CFF stage? It should meet your need.
Posted: Fri Nov 21, 2008 12:55 pm
by chulett
Search is your friend! A quick check for "packed decimal" revealed quite a number of conversations on this topic, including this recent one:
viewtopic.php?t=123152
Posted: Mon Nov 24, 2008 2:40 pm
by bcarlson
You don't treat the whole record as packed, only the numeric fields. Typically the whole record is binary fixed length EBCDIC, then each datatype is handled separately based on the incoming datatype.
An incoming char field will get converted from EBCDIC to ASCII automatically because you specified your input as EBCDIC. Different numeric datatypes will need to be handled differently.
I have a mapping of various numeric mainframe types to their corresponding DS types in the following posting:
Mapping Issue from Mainframe file to Datastage
Hope this helps.
Brad.