Ok, I'm still having problems returning cursors from db2 procedure..

For example:
I have a procedure A, that return a cursor:

CREATE PROCEDURE A ( )
DYNAMIC RESULT SETS 1
P1: BEGIN
DECLARE cursor1 CURSOR WITH RETURN TO CLIENT FOR
SELECT handle, descricao from sam_grau;
OPEN cursor1;
END P1


And I have a procedure B that must to open procedure A and read it like a cursor.

?
How to do this ?


Thanks.

have a look
http://publib.boulder.ibm.com/infoce...c/t0020511.htm

I can't see how can I use the opened cursor inside the caller procedure.
How can I do that ?

Since you specify the cursor as RETURN TO CLIENT, you cannot do that, of course.

Hi stolze, can you send me an example of how can I do this ?

Procedure A opens a cursor and procedure B use this cursor.

Thanks.

Yes, open the cursor WITH RETURN TO CALLER. See the manual for that.