MVSFORUMS.com

Jai · Beginner Joined: 06 Jun 2003 Posts: 57 Topics: 20

Hi,

Please let me know how to call SQL Stored Procedure from Mainframes Cobol Program.Please provide me with some sample code.

And please let me know more information about WLM(Work Load Manager) Environment.
Some info which I have is as follows inside the bracket.

[ DB2 supports two methods of running Stored Procedures. One is running in a DB2-established Address Space of SPAS. The other and recommended way is in a WLM application environment.
Work Load Manager (WLM) is an operating system feature that allows for better management of work like jobs and OLTP.
The main difference is that WLM supports multiple Environments each running in a separate Address Space versus only one DB2-established Address Space.
Multiple environments enable better control and isolation of specific applications or specific types of Stored Procedures.
]

I have some document and going through it. But as I need to implement the Stored Procedures in WLM Environment in my Project soon.So, if anyone can provide me with the sample code, it will be useful for me.

Please let me know all the necessary things to be taken care.

Thanks in advance.
_________________
Have a Great Day.
Thanks & Regards,
Jai

Bithead · Posted: Wed Aug 06, 2003 9:24 am Post subject:

There is a very good Red Book from IBM called "Getting Started with Stored Procedures". It is on the IBM web site.

kolusu · Posted: Wed Aug 06, 2003 10:12 am Post subject:

Jai,

As bithead pointed out, the right thing you need to do is read the manual. check the following for
Getting Started with DB2 Stored Procedures Manual.

The above manual answers all your queries.

Hope this helps...

cheers

kolusu