 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / April 2007query sql server/oracle table from Db2 or join db2 table with sqlserver table
My application connects to a DB2 V8.2 EE database running on AIX. I need to now lookup a table in SQL SERVER via the DB2 connection. I also need to run an sql that joins a DB2 table with an Oracle table. How can I accomplish this ? Do i need a seperate product ? I also have license for Db2 v8 connect that I use for connecting to db2 on the mainframe. TIA Roger > My application connects to a DB2 V8.2 EE database running on AIX. I > need to now lookup a table in SQL SERVER via the DB2 connection. I > also need to run an sql that joins a DB2 table with an Oracle table. > How can I accomplish this ? Do i need a seperate product ? > I also have license for Db2 v8 connect that I use for connecting to > db2 on the mainframe. You need to look at Websphere Information Integrator along with the relational wrappers for MS SQL server and Oracle. Ian, its a canned CRM application that currently connects to DB2. I cannot run the app on Websphere. A few years could use relational connect and create federated nickname on db2. Can I still do that ? TIA > > My application connects to a DB2 V8.2 EE database running on AIX. I > > need to now lookup a table in SQL SERVER via the DB2 connection. I [quoted text clipped - 5 lines] > You need to look at Websphere Information Integrator along with the > relational wrappers for MS SQL server and Oracle. > Ian, its a canned CRM application that currently connects to DB2. I > cannot run the app on Websphere. A few years could use relational > connect and create federated nickname on db2. Can I still do that ? Information Integrator is DB2 with the relational wrappers. So you should be fine. Why IBM decided to put it in the "Websphere" brand is beyond me. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.