RE: Converting EBCDIC to ASCII

From: Bond Mike A Contr OC-ALC/TILC <Mike.Bond_at_tinker.af.mil>
Date: Fri, 17 Aug 2001 07:49:57 -0700
Message-ID: <F001.0036EFFA.20010817073420@fatcity.com>

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: kjanusz_at_att.net

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: ListGuru_at_fatcity.com (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: Mike.Bond_at_tinker.af.mil

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------