>>>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?
I think you are doing normal way, assuming that you have reasonably high number of randomly assorted keys.
Edward Pikman
Independent Consultant