|
Charles, To my knowledge there is NO product out there that can hit multiple databases with a single SQL statement. However, accessing multiple databases in a single application can be accomplished using JDBC as you mentioned (see an example from IBM here - http://www-128.ibm.com/developerworks/websphere/library/techarticles/0407_woolf/0407_woolf.html), and while I cannot locate the exact inference of the announcement, here's something that may help... http://www-106.ibm.com/developerworks/cn/db2/library/techarticles/dm-0411purnell/db2ii_planning_sizing_article_FINAL.pdf. I guess the best thing to do would be to talk to your IBM rep - I just remember reading the blurb and then forwarding it on to someone involved in cross-platform development and support (I'm not currently working with Oracle, so I can only keep track of so much! :-). David R. Sager ITS Project Leader, BPMS Office: (847) 482-2627 Cell: (847) 489-4941 AIM: drsatpca <snip> What announcement are you referring to? I know of no way for DB2/400 to interact "directly" with Oracle unless one ponies up the big $$$ to purchase some extra software from either Oracle or IBM. An iSeries Java application can use Oracle's JDBC driver, but I wouldn't call that DB2 acting "directly". On the other hand, Oracle can use IBM's ODBC or OLEDB driver to directly access iSeries Tables. Note that my definition of "directly" is a single SQL statement can join tables on separate systems. Thanks, Charles <snip>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.