Re: LINK tables on DB2/4

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Not possible on iSeries. The SQL manuals might have techniques to handle 
this. Meanwhile, it's not embedded SQL, but we have a product that can keep 
connections active to different remote databases, so that you can do 
something like what you describe. Check out RPG2SQL Integrator at 
www.rjssoftware.com

HTH
Vern

At 05:10 PM 9/2/2005, you 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?
>
> Thanks
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.