× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Tom:

I suspect that without spending bucks you won't won't find it easy to reference 
tables on two separate systems in SQL (if at all).

This might be a job for RPG.

A DDM file probably could be used easily to bring records from the remote 
system in for processing. The program itself shouldn't be much more complex 
than the SQL statement.

Tom Liotta

midrange-l-request@xxxxxxxxxxxx wrote:

>   3. Can I SQL-query data from 2 servers at the same time? (Tom)
>
>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?


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.