Re: EBCDIC and Packed Decimal for SQL*Loader

From: Bill Manry - Oracle Corporation <bmanry_at_upsizeme.us.oracle.com>
Date: 18 Nov 1994 01:17:23 GMT
Message-ID: <3agvb3$s5i_at_dcsun4.us.oracle.com>


Semyon Basin (sb63_at_aloha.cc.columbia.edu) wrote:
>Is there any way to load an IBM Cobol file with EBCDIC and Packed decimal
>numbers directly into ORACLE using SQL*Loader.

Yes. If you have Oracle on MVS just run SQL*Loader there as usual; the target Oracle database can be local (on MVS) or remote (access via SQL*Net). The input character set is assumed to be EBCDIC and translation to the character set of the target Oracle is automatic. Packed decimal is a supported data type (specify DECIMAL(x,y) in the control file).

If you do not have Oracle on MVS then you're going to run SQL*Loader on what I assume is a non-EBCDIC platform. In this case you have to use the CHARACTERSET option of the LOAD statement to specify the input character set, e.g.
  LOAD CHARACTERSET WE8EBCDIC37 INFILE... Packed data is supported the same as on MVS. It is likely that you will have to include something in the "OS-dependent" options of the INFILE clause to help the UNIX (or whatever) file routines handle IBM record structure.

/b



Bill Manry
Oracle Corp. / Mainframe & Integration Technologies / BManry_at_us.oracle.com #include <disclaimer.usual> Received on Fri Nov 18 1994 - 02:17:23 CET

Original text of this message