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 · Posted: Fri Mar 07, 2014 5:54 pm

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

Did you look at below link?

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

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.