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

If I read that correctly, I can have only connection open at a time.  So I 
would not be able to SQL-query both databases at the same time?

I was hoping to be able to do something like this:

SELECT * FROM SERVER43/PROD/CUSTOMER,SERVER52/PROD/CUSTOMER WHERE ....

Tom

<rob@xxxxxxxxx> wrote in message 
news:OF3FD0CF02.7A7C8A32-ON05257015.00723C89-05257015.00724211@xxxxxxxxxxxx
> http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/db2/rbafzmstetconj.htm#etconj
>
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "Tom" <tomh@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 06/03/2005 03:17 PM
> Please respond to
> Midrange Systems Technical Discussion 
> <midrange-l@xxxxxxxxxxxx>
>
>
> To
> midrange-l@xxxxxxxxxxxx
> cc
>
> Subject
> Can I SQL-query data from 2 servers at the same time?
>
>
>
>
>
>
> I have two AS400s, one at v4r3 (server43) the other at v5r2 (server52).
> Each
> has a database called CUSTOMER, in library PROD.  Using SQL, I need to
> pull data from both servers and combine the data for display.  I'd rather
> not output the data to a temp file unless absolutely necessary.
>
> Using interactive SQL, I issue the commands CONNECT TO SERVER43 (while on
> the v5r2 system) followed by SELECT * FROM PROD/CUSTOMER, and I see the
> data
> from the v4r3 system.  While still connected to SERVER43, I tried the
> following command: SELECT * FROM SERVER52/PROD/CUSTOMER but that failed
> with
> this error:  Relational database SERVER52 not the same as current server
> SERVER43.
>
> Is there any way around this?
>
> Tom
>
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: 
> MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: 
> MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>