Executing a Stored Procedure

paray2x · New User Joined: 28 Dec 2005 Posts: 21

Hi,

I have a COBOL stored procedure. I need to debug it to determine the cause of some issues.

I added some statements to the Cobol stored proc, pre-compiled, bound and stored it in my personal dataset containing the load module.

When I run the program that calls this stored procedure, The procoedure which I compiled does not get called whereas the procedure from Endevor is called.

Can anyone suggest me a way to execute cobol stored procedures from personal datastes ?

Thanks in adavnce

Peter Medina · New User Joined: 10 Oct 2007 Posts: 3 Location: Florida

The DBA must define the address space where the stored procedure runs.
This can be a DB2 address space or a Work Manager(WLM) address space.
It seems this is already done, since you mention Endevor.

So, the stored procedure in your personal library will not work. You may want to compile your program in Endevor that has the address space already defined. Don't forget, when you compile a stored procedure sometimes you or your DBA must re-cycle the address space in order to pick up the new version of your program.