From: Michael Bialik <michael_bialik@my-deja.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Import From DB/2
Date: Tue, 12 Dec 2000 21:34:20 GMT
Organization: Deja.com
Lines: 24
Message-ID: <9165ku$4gv$1@nnrp1.deja.com>
References: <t3clvlcp9mjqb3@corp.supernews.com>
NNTP-Posting-Host: 212.179.147.234
X-Article-Creation-Date: Tue Dec 12 21:34:20 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
X-Http-Proxy: 1.1 x58.deja.com:80 (Squid/1.1.22) for client 212.179.147.234
X-MyDeja-Info: XMYDJUIDmichael_bialik


Hi.

 You can use DB2 UNLOAD utility to extract data from DB2 into flat file.  Use
Oracle SQL*Loader to load that data into Oracle DB.  If your DB2 system is on
mainframe - don't forget to translate from EBCDIC to ASCII.

 HTH. Michael.

In article <t3clvlcp9mjqb3@corp.supernews.com>,
  "Derek Borckmann" <derek@aqssys.com> wrote:
> I have a DB/2 server and I want to move the data to Oracle 7. I do know not
> Oracle very well and would like to know what format I need to export my DB/2
> data to and how to get it in Oracle 7.
>
> Any help would be appreciated.
>
> Derek Borckmann
> derek@aqssys.com
>
>


Sent via Deja.com
http://www.deja.com/