Execution of Stored Procedure

kanak · Moderator Joined: 12 Mar 2005 Posts: 252 Location: India

Hi all,
Can anyone please help me out how to execute DB2 stored procedure through cobol program? What are the prerequisite for the same?

priyesh.agrawal · Posted: Thu Jun 23, 2005 7:32 pm

Hi Kanak,

Whether it helps you ?

http://www.ibmmainframes.com/viewtopic.php?t=1669

Regards,

Priyesh.

kanak · Moderator Joined: 12 Mar 2005 Posts: 252 Location: India

hey priyesh thanks for your quick reply...but it didn't solved my problem.
If you don't mind can you please send me one sample piece of code like how it is being called by passing some value as input to the procedure and how to receive the the output from that procedure. If possible can you send me the JCL for the same also.

Thanks in advance a lot.

MGIndaco · Posted: Thu Jun 23, 2005 9:09 pm

Hi Kanak, after a search in the web I found this link:
http://www.it.ufl.edu/projects/directory/programming/ex-cobol.shtml
that explain in Cobol Code how you can call a stored procedure already defined in DB2.
I hope in this help becuse I never tested it. If it's not what you are looking for I will try to help you with a new search... I can't do anymore...

P.S.= this is the link from IBM Inf. Man. Sw.:
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/samples/mfcobol/s-inpsrv-sqb.htm

kanak · Moderator Joined: 12 Mar 2005 Posts: 252 Location: India

hi MGIndaco.
good morning..Thanks for ur co-operation and reply..will let you know if i have anyother doubt. Thanks once again.