RE: Queries between systems

["MCPARTLAND, Stan" <stanley.mcpartland@xxxxxxxxxx>]

I have not found a way using IBM OS/400 tools to join files across systems.
What I've observed is that you can only connect to one database at a time.
You can join files across systems with Microsoft Access and ODBC.  Just
create a database that has links to the tables on the appropriate systems
and then create a join within Access.  Since the data is transferred to the
desktop for Access to perform the join, you would not want to do this over
large tables.  Due to the performance and some quirks within Access, I copy
the files I need to a single AS/400 via ftp or DDM and cpyf then perform the
join there.  DB2 UDB for Windows might be able to do the join with a
distributed database, but I haven't had the time to experiment with it.

Regards,
Stan

-----Original Message-----
From: Buck Calabro [mailto:Buck.Calabro@commsoft.net]

Rob, how would you do a JOIN across systems?  I can't figure that out
although I haven't spent a tonne of time on it.  I can
connect to sysa
select * from filea
connect to sysb
select * from fileb

...but I can't see how to tell SQL that I want to join the results together.
This sounds like a job for distributed database.
  --buck