RE: Link to DB2

From: Hamid Alavi <hamid.alavi_at_quovadx.com>
Date: Thu, 25 Oct 2001 13:13:51 -0700
Message-ID: <F001.003B5046.20011025132559@fatcity.com>

Tim,

We
have an oracle database(8.1.6) on NT2k and we need retrieve some records from another database DB2 and after some processing on these records store it in our database, these all will be doing thru an web base application.
I am
looking for the best solution to link the oracle to DB2, don't know ODBC or JDBC will work or may be we need some gateway or third part software, I have no idea.


-----Original Message-----From: Johnston, Tim [mailto:TJohnston_at_quallaby.com]Sent: Thursday, October 25, 2001 2:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Link to DB2
 That probably depends on what you need the link for... Can you further define the requirement of what you are trying to do?
 Tim
 PS - I have no experience with them but Oracle does offer Transparent Gateways to other dbms platforms... I'm not 100% sure but I think DB2 is one of them... But depending on your needs it may be more or less then you really need...
 -----Original Message----- From: Hamid Alavi [<A
 href="">mailto:hamid.alavi_at_quovadx.com] Sent: Thursday, October 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: Link to DB2
 List,
 What's the best solution for linking oracle to DB2 Oracle 8.1.6 on NT2K
 Hamid Alavi Office 818 737-0526
 Cell 818 402-1987
 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- <FONT

  size=2>Please see the official ORACLE-L FAQ: <A target=_blank 
  href="">http://www.orafaq.com <FONT 
  size=2>-- Author: Hamid Alavi <FONT 
  size=2>  INET: hamid.alavi_at_quovadx.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists <FONT

  size=2>--------------------------------------------------------------------

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).

The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. Received on Thu Oct 25 2001 - 15:13:51 CDT