• No replies
1 Post

Pinned topic Using curor marked "WITH RETURN TO CLIENT" in a stored procedure

‏2013-09-18T20:12:46Z | "with client" procedures return stored to

I have to use a  DB2 stored procedure that returns results with a cursor defined as "WITH RETURN TO CLIENT".  I do not have control over this SP so I cannot "just" change the cursor to "WITH RETURN TO CALLER"; (anyways, this would change the procedure profoundly).  I need to access the cursor from another stored procedure (for massive testing purposes).  The cursor is invisible because it is to be passed through to the client.  Do you have any idea how to obtain access to this cursor from within a stored proc?