RE: sql select from to servers

How I would do this depends upon the file sizes. If they files aren't too big, 
I'd just copy it over from the other system. You can also use MS Access to do 
this against two systems but it's going to be slow. If the files are big enough 
that a copy isn't going to work, you could write an embedded SQL program that 
reads every record on one system and that goes to the remote system to see if 
the record exists or not. 

Which ever method you choose, you'll need to do this both ways (compare system 
A to system B and system B to system A) to find all of the differences.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Raul A. Jager W.
Sent: Friday, April 22, 2005 8:38 AM
To: RPG programming on the AS400 / iSeries
Subject: sql select from to servers


I have two AS/400, each has a copy of a file, almost identical.  I need 
to find the diferences, one of them has 12 more records.  If they where 
in the same computer I could
"select * from lib.file1 where key is not in (select key from lib.file2)"
but I did not find the way to use both servers in the same SELECT.  if I 
use "server.lib.file" it only works for the server that I am connected.  
How can I connect to two servers in the same SQL?

TIA
Raul


-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.