Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL *Loader load data from MVS EBCDIC files
Kunj wrote:
> Could any tell me how to load data into oracle 9i. The data is
> unloaded from DB2/MVS 5 environment.
>
simple use
characterset WE8EBCDIC500
greetings
volker
ex:
options (silent=(discards))
load data
characterset WE8EBCDIC500
infile "../daten/sa0.dat"
replace
into table EXT_BANKVERZ
trailing nullcols
(
BANK position ( 11: 14), BLZ position ( 17: 24) , NAME position ( 27: 70)) Received on Fri May 28 2004 - 06:57:31 CDT