Re: SQL *Loader load data from MVS EBCDIC files

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.
>
> The ftp running on the MVS can certainly do the translation to ascii
> when you 'put' the file to the ascii-based machine.

If the data was extracted from DB2 into fixed or delimited character format then the FTP as Ed said will handle the EBCDIC to ASCII conversion and sqlldr will not know or care where the data came from. We move data from IMS (mainframe hierarchical database) to Oracle and back this way every day.

If on the other hand the data was extracted in native machine format such as packed decimal then it would be best to write a program on the mainframe to convert the data to character. This will make reloading the data much simpler

HTH -- Mark D Powell -- Received on Sat May 29 2004 - 10:04:53 CDT