Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

[Article]Stored Procedures - DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
praba_jas

New User


Joined: 01 Apr 2005
Posts: 11

PostPosted: Tue Jul 26, 2005 6:06 pm    Post subject: Stored Procedures - DB2
Reply with quote

Hi,

Can anybody help me out with sample programs for db2 stored procedures written in cobol.
Already gone thru the forum.but not getting sample programs

Advanced Thanks,
J.Jasmine
Back to top
View user's profile Send private message

habibullah_j

New User


Joined: 16 Mar 2006
Posts: 3

PostPosted: Fri Mar 17, 2006 3:38 pm    Post subject: Re: Stored Procedures - DB2
Reply with quote

Jasmine,
Cobol stored procedure is like ordinary cobol-DB2 program containg all the divisions such as Identification division, Data division and procedure division. You have to compile it and then build. we are using changeman to do this. Suppose if your SP have to return more than one row then you have to declare a cursor and open it, no need of fetching.
I dont know how you are going to call this SP but if you want to pass some values to the sp then you have to use Linkage section.
Kindly revert it back if there is any issues..

cheers,
habib...
pune.
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 -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Is possible to call subprogram from c... cmsmoon COBOL Programming 3 Fri Aug 05, 2016 6:46 pm
This topic is locked: you cannot edit posts or make replies. Stored procedure on Federated thru DB2 arif677 DB2 6 Tue May 31, 2016 11:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us