Re: SQL *Loader load data from MVS EBCDIC files

From: Dave <Nospam_at_PublicAccessuNIX.com>
Date: Thu, 27 May 2004 14:02:27 -0400
Message-ID: <c95afn$qgu$1@reader2.panix.com>

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:us7cb01a12aea278mlmnfi8eqvfp1frfcg_at_4ax.com...
> On 27 May 2004 01:54:25 -0700, kunjumon_at_alex4all.com (Kunj) wrote:
>
> >Could any tell me how to load data into oracle 9i. The data is
> >unloaded from DB2/MVS 5 environment.
> >
> >Please explain the steps
> >
> >Regards
> >Kunj
>
> Replying only in the NG in which I read this . ..
>
> If SQL*Loader doesn't provide that kind of translation, then it must
> assume that the input is in the encoding scheme of the platform on
> which it is running.

SQL*Loader can do EBCDIC to ASCII translation. While it assumes the characterset specified in the NLS_LANG parameter on the system on which it is running, that can be over ridden in the control file with a command similar to "LOAD DATA CHARACTERSET WE8EBCDIC500".

> The ftp running on the MVS can certainly do the translation to ascii
> when you 'put' the file to the ascii-based machine.

While this is also may be a solution, it would generate problems for a file of mixed data types.

Regards,
Dave Received on Thu May 27 2004 - 13:02:27 CDT