This ia a question for both SQL server and Oracle. I'm testing with SQL server first, but I eventually need to offer both options.

I have a situation where I create remote cursor with SQLexec(). Then I need to create a second cursor with a join of some other table to the first cursor.

Of course, my first cursor is now on my machine, not the server, so I can't ask an SQLexec to join something to it. But, I thought, maybe there is a way to tell SQL server to keep the cursor on the server (as well as sending it to me), for reuse in the next SQLexec() statement. Anyone know how?

TIA. Tom