Re: IBM EBCDIC to ASCII conversion [message #69784] |
Tue, 05 March 2002 14:43 |
Nathan Eaton
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
Just for clarification, John, do I understand correctly that you are describing using SQL*Loader with a file transferred from an EBCDIC platform to an ASCII platform and using a control file that has:
- FIX n (to describe the logical record length)
- CHARACTERSET=WE8EBCDIC500 (to indicate the input is EBCDIC)
- POSITION(*) and DECIMAL(n) for each packed decimal field in the input record (to let SQL*Loader correctly identify the length of the packed fields)
Some folks I work with indicated their problem was that SQL*Loader didn't correctly interpret EBCDIC-to-ASCII conversion of packed decimal data. I'm trying to convince them that this will work but want to have my facts straight first.
|
|
|