Re: SQL *Loader load data from MVS EBCDIC files
Date: Fri, 28 May 2004 01:25:05 GMT
Message-ID: <Rxwtc.25620$SQ2.831_at_edtnps89>
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 Fri May 28 2004 - 03:25:05 CEST