| 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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
