Hi - How do we handle the comp-3(packed decimal) with hex data in complex flat file? is there a separate option to handle this ?
[* Note - Title changed to be more descriptive - Andy *]
How do I load comp-3 (packed decimal) data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 150
- Joined: Tue Mar 13, 2007 1:17 am
-
- Participant
- Posts: 150
- Joined: Tue Mar 13, 2007 1:17 am
because that is how the source team defined it. I dont understand much about it so I might not be wording it properly. However, Please refere to the link Linkhttp://www.simotime.com/datapk01.htm In the second table it has defined the positive and negative Hex data. which I am not able to read using CFF. So, Could you please help me?
OK, that's what I was afraid of. COMP-3 is packed decimal and packed is packed, not even EBCDIC or ASCII technically, just... packed. It can look like hex data if you look at the raw data, but it isn't.
Why are you "not able to read it" using the CFF? What exactly are you doing and what errors are you seeing? It should handle them just fine unless you are doing something like converting the file from EBCDIC to ASCII during the file transfer, which will destroy the packed data.
Why are you "not able to read it" using the CFF? What exactly are you doing and what errors are you seeing? It should handle them just fine unless you are doing something like converting the file from EBCDIC to ASCII during the file transfer, which will destroy the packed data.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers