SQL*Loader -- loading EBCDIC-DB2[as400] packed decimals
Hi,
We have a flat file that we are trying to load into Oracle [tried version 8.1.7.0.0 and 9.2.0.1.0]. The flat file is a direct physical ftp from an AS400/DB2 and has a number of packed decimal fields and comes down in EBCDIC.
LOAD DATA
CHARACTERSET 'WE8EBCDIC500'
INTO TABLE asciitest
(
COL1 position (01:03) DECIMAL(4,0),
COL2 position (04:12) CHAR,
COL3 position (13:21) CHAR,
COL4 position (22:26) DECIMAL (9,2),
COL5 position (27:29) CHAR
)
with this script i am able to parse the CHAR data successfully however the packed decimal never work. They do get inserted into the fields but the when u select * from asciitest you get non-sensical results (ie characters instead of digits)
I've read some documents on SQL_Loader and it lead to me to beleive that it would be able to handle these numbers. Am I wrong? Is there anyway this can be done (with out 3rd party software)??