RE: Can I SQL-query data from 2 servers at the same time?

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Rob,

I hope you pointed out to the unnamed IBMer how silly this limit is.

DB2 LUW doesn't have this same limit.  Heck, with the availability of ODBC and 
OLEDB drivers for other databases, DB2 LUW can even join local tables to tables 
in Oracle or SQL Server.  The same thing holds true in reverse for Oracle and 
SQL server.

It's no wonder people are moving data off the iSeries.  It just so dang easy to 
pull the data off to another platform; whereas is impossible to pull data back 
to the iSeries without big bucks.  The last straw is even if you spend the 
bucks to get what's needed to access data on another platform, you can't easily 
make use of it since DB2 iSeries doesn't support a connection between more than 
one system at the same time.


Just my .02 .... gotta go help the Oracle guys tie into the iSeries.


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
> Sent: Monday, June 06, 2005 10:32 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: Can I SQL-query data from 2 servers at the same time?
> 
> 
> An IBMer off list responded to me with:
> 
> "That type of join requires a higher level of DRDA than 
> iSeries supports. 
> Websphere Info Integrator and DB2 Connect do have that level of DRDA 
> support. "
> 
> These ain't freebies.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
>