IBM Mainframe Forum

Hello,

I have to use a cursor returned from DB2 stored Proc (extrenal) in COBOL program. Can anyone tell me how it is done.

To elaborate, there is one external DB2 stored Proc (external) written in PL/SQL in DB2. It will retrieve values in cursor. And I need to access the values fromthe cursor and use it for further processing. Does anyone has any experience in using such external DB2 stored Proc in COBOL program?

Thank you,
Yogesh

Presumably the people who gave you that assignment so why not ask them?

We have just started using it recently and at this point, no one has clear idea.
At this moment, we are just using the SQL return code and SQL Messages at this moment, and we would like to get more data from the external stored proc.

I understand its little difficult to get the data however, any pointers to 'good' online material would be helpful.

Tks,
Yogesh

what happened when You googled with return cursor stored procedure db2 ???

http://publib.boulder.ibm.com/infocente ... cedure.htm

The example is good to start with. Yesterday, someone told me, RESULT SET is the way do it.
If I have any questions, I will post them again. And thank you for the sample program.