RE: data cleansing question

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Mon, 22 Apr 2002 14:07:02 -0800
Message-ID: <F001.0044BA9C.20020422140702@fatcity.com>

Stefan,

> I've got a question regarding your migration host -> oracle,
> since I'll have
> the same
> problem in the near future.
> How do you deal with the EBCDIC to ASCII problem ?
> Do you migrate from VSAM or DB2 ? Which version of Oracle are you on ?

Can't reply to the second one, but take a look at the 'dd' UNIX command with the conv=ascii parameter for EBCDIC to ASCII conversions. Do be careful though: Stuff can be present in 7-bit and work differently...

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!

• The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com

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). Received on Mon Apr 22 2002 - 17:07:02 CDT