|
Can you not copy the remote file to a local work file and do the join then? If you can connect to the remote system, assuming it is an AS/400 (if not tell the list how you are connecting those two databases), you can use an SQL statement to insert the remote data into the local work file (I think, never tested this). A slower option is use two SQL statements: the first statement reads the local file; based on the join values fetch the record(s) from the remote file with the second statement. A third option: do not use embedded SQL then. The DDM file can be accessed with native I/O (RPG). Just some thoughts. Regards, Carel Teijgeler *********** REPLY SEPARATOR *********** On 2-9-05 at 15:10 Mohammad, Tanveer wrote: >Is there anything similar to LINK tables on DB2/400 so that I can use >SQL over them? I know there are DDM files but problem is that embedded SQL >doesn't work on them? > >I need to be able to join two tables one is on local machine and the >other one on remote machine, can I do it or, it is not possible at all?
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.
midrange.com
