Page 1 of 1

Fetching Cursor from a DB2 Stored Procedure

Posted: Mon May 12, 2008 12:47 pm
by horserider
I am executing a Stored Procedure from STP Stage. It is creating and populating my resultset with the data I want in a cursor. The DBA says in order to get the data from cursor, I have to "Fetch" the cursor and then read the cursor till end of data.

"How do we READ/ACCESS the CURSOR through Stored Procedure Stage"?