DB2 stored predure on mainframes

koteswara · New User Joined: 23 Sep 2009 Posts: 22 Location: Bangalore

Hi,

We need to move a stored procedure from dev to test environment on mainframes.

Have used Spufi for compiling the stored procedure.But we can't access spufi in test. Needs to be moved through a jcl.

FYI.. this stored procedure is accessed by an external system.

Any help is highly appreciated.

Thanks in advance

enrico-sorichetti

since we do not belong to Your organization..
we do not know Your organization standards, practices, tools
ask Your support or Your peers
if this is the first time that a stored procedure is <promoted>
Your support should be involved to define the standards for such a task from now on

Rohit Umarjikar · Posted: Fri Mar 07, 2014 9:53 pm Post subject:

Did you look at below link?

https://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.apsg%2Fsrc%2Ftpc%2Fdb2z_prepareexternalspjcl.htm

koteswara · New User Joined: 23 Sep 2009 Posts: 22 Location: Bangalore

Thannk you all

https://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.apsg%2Fsrc%2Ftpc%2Fdb2z_prepareexternalspjcl.htm

Came to know that Native stored procedure is creating a package with
the name as stored procedure name.

At the same time owner should have the package admin access for creating binding this stored procedure.