Re: Access mult DB with SQLRPGLE at 7.3?

<Charles>
I think he wants to do something like

select *
from server1.lib1.tab1
join server2.lib2.tab2

In which case, no nothing has really changed.

The exception is that you can now do
create table locallib.localtbl
as (select * from remotesvr.remotelib.remotetbl)

directing within DB2 for i, ARDgate not needed.

Charles
</Charles>

Charles,

just some corrections:
- If you want to query a non DB2 database (ArdGate or some more expensive additional tools are needed) nothing has changed!!!
- redirect a query to an outfile isn't that new, QMQRY has this capability since 15 years and this worked with ArdGAte from the very first day (> 10 years)
- joining tables from multiple databases won't perform as expected - in last consequence you would have to pull all tables to one machine and joining them there.

D*B
who has read more informative postings of Charles (everybody might have good days and not so good days...)