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

Vern,

Thanks for the heads up. I saw no info about RPG2SQL on the website (there 
is a download link for it) so I've filled out the requisite "call me" form, 
waiting for a call back.

Tom

"Vernon Hamberg" <vhamberg@xxxxxxxxxxx> wrote in 
message news:6.2.0.14.2.20050604115044.030f2348@xxxxxxxxxxxxxxxxxxx
> <vendor response>
>
> Tom,
>
> Our RPG2SQL product can talk to any number of remote databases, all open 
> at the same time. It uses a CLI-like (ODBC-like) syntax for connecting and 
> reading and writing records. You would use the native -like method of 
> getting a master record from one source, then read the related detail from 
> another source. And these sources can be completely separate remote 
> databases.
>
> See www.rjssoftware.com if you are interested.
>
> </vendor response>
>
> At 03:17 PM 6/3/2005, you wrote:
>
>>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.
>
>