Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL *Loader load data from MVS EBCDIC files

Re: SQL *Loader load data from MVS EBCDIC files

From: Volker Pohlers <volker.pohlers_at_gmx.net>
Date: Fri, 28 May 2004 13:57:31 +0200
Message-ID: <2honk9Fb7u43U1@uni-berlin.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US