Stored Procedures: RESULT SET.

#1

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?

#2

db2sysc (AT) yahoo (DOT) com wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Stored Procedures: RESULT SET.

comp.databases.ibm-db2 comp.databases.ibm-db2

Stored Procedures: RESULT SET. - 05-02-2005 , 07:27 AM

Re: Stored Procedures: RESULT SET. - 05-02-2005 , 07:44 AM