By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,611 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,611 IT Pros & Developers. It's quick & easy.

Stored Procedures: RESULT SET.

P: n/a
All:

I am writing a MAIN CALLING PROCEDURE. This call lot of procedures.
Some of the CALLED PROCEDURES end with an OPEN C1 (cursor). How to I
read this open cursor in my main procedure?? In java or C we can
process this return cursor. But I am not sure if we can process the
cursor in the MAIN CALLING PROCEDURE.

Any help?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
db*****@yahoo.com wrote:
All:

I am writing a MAIN CALLING PROCEDURE. This call lot of procedures.
Some of the CALLED PROCEDURES end with an OPEN C1 (cursor). How to I
read this open cursor in my main procedure?? In java or C we can
process this return cursor. But I am not sure if we can process the
cursor in the MAIN CALLING PROCEDURE.

Any help?

Take a peek at teh WITH RETURN option for cursors and the
ASSOCIATE and ALLOCATE LOCATOR statements that let you "catch" a resultset.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.