RE: DB2/400 UDB Connection to Oracle

[Jim Knight <jknight@xxxxxxx>]

Bleddyn,
If you are coming from NT, I believe Oracle uses ODBC for the
connection.  If you are coming from a RS/6000, you can use the 
Oracle gateway for AS/400, as long as you are doing data 
retrieval.  You set up a private or public database link to the 400 
and SQL statements are resolved on the 400 and data returned.   \
If you are looking for a REPCAT function for data replication, 
you'll need to look at Data Mirror, MIMIX, or Vision.  
Jim K

-----Original Message-----
From: Bleddyn Williams [mailto:bleddyn@MORPHEUS.LTD.UK]
Sent: Tuesday, January 25, 2000 10:08 AM
To: MIDRANGE-L@midrange.com
Subject: DB2/400 UDB Connection to Oracle


Has anyone set up an SQL connection from the 400 to an Oracle database if so
what did you use? It looks like IBM's Data Joiner is one product but it
needs to run on a PC sitting in the middle, is there anything that sits down
at the Oracle end, and does it only support an SNA connection?

Thanks
Bleddyn

***********************************************************
http://www.ignite400.org Your AS/400 Internet User Group
***********************************************************

+---
| 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
+---
+---
| 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
+---