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_at_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 - 13:57:31 CEST

This message: [ Message body ]
Next message: Curtis: "Re: Oracle Forms, add text to text item"
Previous message: KHURRAM: "Please Please Help!!! Web Forms 6i Memory Leak"
In reply to: Kunj: "SQL *Loader load data from MVS EBCDIC files"
In reply to Kunj: "SQL *Loader load data from MVS EBCDIC files"
Next in thread: Curtis: "Re: Oracle Forms, add text to text item"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message