|
>I assume you mean filea is on one system >and fileb is on another and you want to >join them together. >I don't use OPNQRYF. With any luck it >won't [work], instead encouraging you to >use SQL. 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 mailing list archive is Copyright 1997-2024 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.