|
|
| Author |
Message |
praba_jas
New User
Joined: 01 Apr 2005
Posts: 11
|
|
|
|
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 |
|
 |
References
|
 Posted: Tue Jul 26, 2005 6:06 pm Post subject: Re: Stored Procedures - DB2 |
|
|
|
|
habibullah_j
New User
Joined: 16 Mar 2006
Posts: 3
|
|
|
|
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 |
|
|
|
|
