>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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.