Fetching Cursor from a DB2 Stored Procedure

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
horserider
Participant
Posts: 71
Joined: Mon Jul 09, 2007 1:12 pm

Fetching Cursor from a DB2 Stored Procedure

Post 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"?
Top
Post Reply

Return to “General”