Re: sql select from to servers

SQL doesn't work on ddm files.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Paul Morgan" <pmorgan@xxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/22/2005 09:54 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Subject
Re: sql select from to servers






Raul,

If you have communication between the two systems you could create a DDM
file on one system that pointed to the file on the other system.  Put the
DDM file into a different library or just name the DDM file with a 
different
name than the file you're comparing against.  This DDM file could then be
used in a SQL statement along with the physical file you're comparing
against.  Not very great for performance but it'll get the job done.

Instead of using the DDM file directly you could use the DDM file as a
method to copy over the file for comparison (instead of using FTP,
save/restore or SNADS).  Create the DDM file.  Use CPYF CRTFILE(*YES)
FROMRCD(1) to copy over the file.  Run your SQL comparison against the
copied file.

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333

Raul wrote

> 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.