IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

[Article]Stored Procedures - DB2


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Infosphere Optim - unable to save Col... IBM Tools 0
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
No new posts user exits in Column Map procedures IBM Tools 0
This topic is locked: you cannot edit posts or make replies. Internal Autonomous Stored Procedure ... DB2 6
Search our Forums:

Back to Top