Re: LINK tables on DB2/4

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

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?