What do you understand under "execute" the stored procedure? It will run in your WLM Address Space and you must put your Linklib (the Linklib with the module) in the WLM Address Space JCL. If you mean how to call it, it is the same way you do with other stored procedures.
Give a look at this Redbook
<a href="http://www.redbooks.ibm.com/abstracts/sg247604.html?Open">
http://www.redbooks.ibm.com/abstracts/sg247604.html?Open
</a>
and at this page in the information center.
<a href="http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_xmpplistoredproceduregeneralwithnulls.htm">
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_xmpplistoredproceduregeneralwithnulls.htm</a>
You should find what you need.
Last Wiki Answer Submitted: July 18, 2008 1:34 pm by RodneyKrick265 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.