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.
>
> Please explain the steps
>
> Regards
> Kunj

Is the data in a 'describable' layout? In other words, is there a known data field layout in the 'unload file' that can be mapped to one of more tables, whether on a single record? This is valid, even if the file data spans across multiple records using some sort of continuation identifier.

If so, you can use SQL*Loader - Oracle's native load utility - to load the data, or possibly External Tables. (External Tables basically use SQL*Loader to map and 'read' the external file, and then make the data available as a read-only table available in SELECT statements.)

If charset conversion is an issue. SQL*Loader uses Oracle's Globalization capability to convert from the data from the character set specified using the NLS settings to the character set required by the database. (See: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch05.htm#1008087)

The documents I recommend are:

http://docs.oracle.com >> database version documentation (for 9,2 this is http://otn.oracle.com/pls/db92/db92.homepage)

under List of Books:

Concepts
Globalization Support Guide
Utilities

HTH/Hans Received on Thu May 27 2004 - 20:25:05 CDT