Re: DB2 to Oracle

Hi, sometime ago I answered a question similar to yours (but for SQL Server), 
but
the answer was just as good.
I'm copying it down. Hope this helps.
==========================================================
My former response was:

Maybe IBM's " DB2 DataJoiner " can help you? It allows access to SQL Server and
Oracle (among other) from different environments. AS/400 is one of these. But in
the case of AS/400 I believe it requires having an IPCS in the AS/400 (not sure)

This product was announced July 28, 1998 . Find its announcement in US 
Ann.Letter

298-264. At bottom of that page you can request a .pdf file with the
announcement.

Other info of interest:

IBM DB2 DataJoiner Version 2.1.1 (don't know if there's a more updated one...)
look into   http://www-4.ibm.com/software/data/datajoiner/brochure/index.html

Product number:
Redbook for Planning SG24-2566
Document: Planning, Installation and Configuration Guide: SC26-9150

Config DBJoiner for DB2 UDB for AS/400
http://www.as400.ibm.com/developer/bi/datajoiner.html
(here you get a reference of using it in the AS/400 thru IPCS)

DRDA Config (for AS/400):
http://www.as400.ibm.com/developer/bi/datajoinersteps4.html

Accessing a MS SQL Server database
http://www.as400.ibm.com/developer/bi/datajoinersteps3.html

DBJoiner config for DBServer Access
http://www.as400.ibm.com/developer/bi/datajoinersteps5.html




"Goodbar, Loyd (AFS-Water Valley)" escribió:

> I've checked the archives, but turned up little.
>
> I want to use the AS400 as a client to access data from a Microsoft SQL
> server (V7) database. [The database & server is in another location in
> another state, so cannot be put on our AS/400. Also corporately mandated the
> data is on the NT server.] One solution I've heard is "use DRDA". Does MS
> SQL server have a DRDA component to allow access from the AS/400? Another
> idea is to run SNA server on an NT box to broker ODBC connections for the
> AS/400.
>
> Does anyone have this working? Any advice is appreciated!
>
> --
> Loyd Goodbar
> Programmer/Analyst
> BorgWarner Incorporated
> Air/Fluid Systems, Water Valley, MS
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

--
-----------------
Antonio Fernandez-Vicenti
afvaiv@wanadoo.es


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---



Kevin Corcoran escribió:

> Hi,
>
> Does anyone know of any product (other than IBM's DB2Connect) that will
> allow the transport of data from a DB2 database to an Oracle database?
>
> (The aim is to move an entire database from AS400 to Oracle/Sun - not my
> decision sadly, or it would stay where it is).
>
> TIA.
>
> Kevin.
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

--
-------------------------
Antonio Fernandez-Vicenti
afvaiv@wanadoo.es


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---