How to read the Packed format characters in Sequential File
Moderators: chulett, rschirm, roy
-
ratikmishra1
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
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
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.
It is not that I am addicted to coffee, it's just that I need it to survive.