>>I'm pretty sure of the respond but, is there a way to make (like) a join
>>between a remote and a local table using SQLExec. The way I did is I do a
>>scan from the local table and I go retrieve the info. I want from the remote
>>table. I hope there is a better solution. Thanks!
>
>SQLExec will retrieve a cursor, and this cursor can be joined to local table. I am not sure, it's what you are asking...
I will be more specific, sorry!
I have a local cursor wich have all the primary keys I want to access in the server. I want
to retreive specific information on the server using the primary key. But I can join
a Local cursor to a remote table. So, I loop through the local cursor and use SQLExec
to retreive one row at a time. Is there another "better" way to do this?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only