convert EBCDIC to ASCII using sqlloader
544084Feb 8 2007 — edited Feb 8 2007hi..
i have .dat file which extract from mainframe in EBCDIC format n i have to load in table using sqlloader.
here, my .ctl sample:
AMTV2_RESERVE08 POSITION(857:861) DECIMAL(9,2),
AMTV2_RESERVE09 POSITION(862:866) DECIMAL(9,2)
here, my record layout
10 IN4331A-AMTV2-RESERVE08
PICTURE IS S9(7)V99
USAGE IS COMP-3
ELEMENT LENGTH IS 5
POSITION IS 857
10 IN4331A-AMTV2-RESERVE09
PICTURE IS S9(7)V99
USAGE IS COMP-3
ELEMENT LENGTH IS 5
POSITION IS 862
when i run the sqlloader, i got this error:
Invalid packed decimal nibble.
what must i do?
thanks