MVSFORUMS.com

Manas Biswal · Posted: Sat Dec 07, 2002 1:47 am Post subject: DB2 Stored Procedures

Hi,

I need some help with DB2 Stored Procedures. I am coding a stored procedure in LE/COBOL. Now, I need to compile and link-edit it. I have heard that you have to include some call attach facility library while link-editing the stored procedure. Can anyone provide me some information on that. If someone can provide me with a sample JCL for link-editing the stored procedure with Call Attach Facility, that will be great.
I am trying to declare and open a cursor in the stored procedure and then fetching the cursor in my calling program using ASSOCIATE LOCATOR. If someone can provide me with some sample code on that(both calling program and stored proc) then that will be great.

Regards,
Manas

kolusu · Posted: Sat Dec 07, 2002 9:44 am Post subject:

Manas biswal,

check this as it answers most of your questions.

Using stored procedures

Hope this helps...

cheers

kolusu