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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2022 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.