Page 1 of 1

Getting values from cursor of a external DB2 stored proc

PostPosted: Wed Oct 10, 2012 11:48 pm
by yogeshvalhe
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

Re: Getting values from cursor of a external DB2 stored proc

PostPosted: Thu Oct 11, 2012 4:13 am
by NicC
Presumably the people who gave you that assignment so why not ask them?

Re: Getting values from cursor of a external DB2 stored proc

PostPosted: Thu Oct 11, 2012 4:31 am
by yogeshvalhe
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

Re: Getting values from cursor of a external DB2 stored proc

PostPosted: Thu Oct 11, 2012 4:56 am
by enrico-sorichetti
what happened when You googled with return cursor stored procedure db2 ???

Re: Getting values from cursor of a external DB2 stored proc

PostPosted: Thu Oct 11, 2012 4:30 pm
by GuyC

Re: Getting values from cursor of a external DB2 stored proc

PostPosted: Thu Oct 11, 2012 4:55 pm
by yogeshvalhe
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.