We do not pull data directly from IMS but load it in batch jobs. Our
mainframe guy either dumps the data report-style (ASCII) or copies records
in native EBCDIC to files on the mainframe. We ftp them to the Oracle side
(binary mode to EBCDIC files) and use sql loader to move into Oracle. On
the files that come over in EBCDIC, I use sqlloader with the following in
the control file. There are a few bugs with loading EBCDIC (search
metalink) but we manage to get it loaded.
LOAD DATA
CHARACTERSET WE8EBCDIC500
INFILE 'e:\filename.dat' "fix 688"
...
-----Original Message-----
Sent: Friday, August 17, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L
I may be moving data from an IMS db which is stored in
EBCDIC. Oracle stores data in ASCII format. How do I
go about converting EBCDIC to ASCII to store the data in
Oracle (8.1.?)?
Thanks,
Ken Janusz, CPIM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bond Mike A Contr OC-ALC/TILC
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
