Home » RDBMS Server » Server Utilities » Re: IBM EBCDIC to ASCII conversion
Re: IBM EBCDIC to ASCII conversion [message #69511] Thu, 24 January 2002 04:13
John Griffiths
Messages: 1
Registered: January 2002
Junior Member
EBCDIC Packed decimals can be handled by SQL*Loader, however it is difficult when using POSITION to indicate the bytes to read as packed decimals require less bytes than the data length indicates, therefore easier to specify the control file using POSITION(*) and specify the data length as DECIMAL(n) and SQL*Loader wiill calculate how many bytes to read. E.g. DECIMAL(9) will read 5 bytes (10/2 + 1).
Previous Topic: Re: Oracle Password with Connect internal
Next Topic: Export utility options
Goto Forum:
  


Current Time: Sat Mar 02 13:31:24 CST 2024