Re: Data Extraction from DB2 to Oracle

From: Bill Manry <B.Manry_at_upsizeme.us.oracle.com>
Date: 1997/05/27
Message-ID: <5mfl8l$33p$1@inet16.us.oracle.com>#1/1

Sudheer Marisetti (marisett_at_bellatlantic.net) wrote:
>I happened to hear that there is a way of extracting data from DB2
>database to Oracle database via SQL. We have DB2 running on an AS/400
>and Oracle on HP 9000. We were told that Oracle on HP has a way of
>extracting data from DB2 to Oracle using SQL. If any of you are aware of
>any such tool or methodology I would appreciate if you could share it
>with us.

Oracle has two gateway products that will let you pull DB2/400 data into Oracle on HP with a SQL INSERT statement:

Oracle Transparent Gateway for DB2/400
Oracle Transparent Gateway for IBM DRDA

These products differ in where they run (AS/400 and UNIX, respectively) and in certain other respects (the former runs over TCP/IP or SNA but the latter requires SNA; the latter can talk to DB2 on other platforms such as MVS).

--
Bill Manry  -  IBM Products Division  -  Oracle Corporation
These are my opinions, not necessarily Oracle's.
Remove "." from "B.Manry" to email me.

Received on Tue May 27 1997 - 00:00:00 CDT