How do I maintain a cursor per client?

I have a middle-tier server process with ProC code. Many clients call the server.

SELECTs may return a large number of rows, so I want to hand back only 100 at a time to the client. However, this would mean the client would need to call me subsequent times to retrieve the next 100 rows, etc.

But another client, executing the same query, would stomp on the cursor.

Is there a way to create a unique cursor per client, that can be kept open across subsequent calls? (Or, more generally, a way to return an unbounded number of rows to a client.)

BTW, I tried looking into Contexts, which look promising, but have few coding examples to work with.

thanks,
--Hans Received on Mon Jul 13 1998 - 11:16:33 CDT