Invoke a stored procedure (SQL) from a COBOL program

a69356 · New User Joined: 01 Dec 2006 Posts: 21 Location: Gurgaon

I need to invoke a stored procedure (SQL) from a COBOL program. The stored procedure returns ONE result set, so the last (meaningful) statement in the stored procedure is OPEN cursor name.
PLease let me know how will I do this?

It will of great help if anyone can provide me the sample code for this?

Thanks in advance.

a69356 · New User Joined: 01 Dec 2006 Posts: 21 Location: Gurgaon

My question is that When I call the stored procedure from the Cobol program then how will the SP(Stored Procedure) returns the resultset back to the calling program and how will the calling Program will handle it.As the last meaningful statement in the SP is OPEN Cursor.

Thanks

ksk · Posted: Mon Sep 22, 2008 9:44 am

In our shop, JAVA program extracts the result set. Open cursor will open the cursor and make available the rows to extarct either thru front end (like JAVA)or back end (Cobol-db2 program that calls SP).

As for as I know if u want to extract rows from back end, you have to fetch the rows from the program that calls the SP.

die7nadal · Active User Joined: 23 Mar 2005 Posts: 156

This is the link for the pdf that describes how to handle the results in a calling program. I haven't gone through this pdf, but have gone through an earlier verion of this document and found it very helpful. http://www.redbooks.ibm.com/abstracts/sg247604.html?Open

die7nadal · Active User Joined: 23 Mar 2005 Posts: 156

Never mind the link I sent, it may not apply to you.

a69356 · New User Joined: 01 Dec 2006 Posts: 21 Location: Gurgaon

Thankyou very much.it is very helpful document. again thanks a lot