Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Execution of Stored Procedure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kanak

Moderator


Joined: 12 Mar 2005
Posts: 252
Location: India

PostPosted: Thu Jun 23, 2005 7:27 pm    Post subject: Execution of Stored Procedure
Reply with quote

Hi all,
Can anyone please help me out how to execute DB2 stored procedure through cobol program? What are the prerequisite for the same?
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Thu Jun 23, 2005 7:32 pm    Post subject: Re: Execution of Stored Procedure
Reply with quote

Hi Kanak,

Whether it helps you ?

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

Regards,

Priyesh.
Back to top
View user's profile Send private message
kanak

Moderator


Joined: 12 Mar 2005
Posts: 252
Location: India

PostPosted: Thu Jun 23, 2005 7:57 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Thu Jun 23, 2005 9:09 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
kanak

Moderator


Joined: 12 Mar 2005
Posts: 252
Location: India

PostPosted: Fri Jun 24, 2005 10:03 am    Post subject:
Reply with quote

hi MGIndaco.
good morning..Thanks for ur co-operation and reply..will let you know if i have anyother doubt. Thanks once again.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us