DB2 Remote stored procedure bind deploy change request

SYSTEM:DB2 Remote stored procedure bind deploy
We use the below JCL to move DB2 stored procedures from remote DB2 test environment DB2 Production environment. The qualifier/schema changes between test and production.

//JS010 EXEC PGM=IKJEFT1B,DYNAMNBR=20

//STEPLIB DD DSN=B0SADD0.ADD0.SDSNLOAD,DISP=SHR

//SYSIN DD DUMMY

//SYSTSPRT DD SYSOUT=*

//SYSPRINT DD SYSOUT=*

//SYSUDUMP DD SYSOUT=*

//SYSTSIN DD *

DSN SYSTEM(ADD0)

BIND PACKAGE(ADP0.SP_TEST) -

DEPLOY(DEV.SP_TEST) -

COPYVER(V1) ACTION(ADD) -

QUALIFIER(PRD) -

EXPLAIN(YES) -

OWNER(FSGDBA)



Description:

We use “DB2 remote bind deploy” to move stored procedure code from non-production to production. The QUAILIFIER parameter is used to change the object schema from source ‘DEV' to target ‘PRD.' This works for table objects. However, for user defined functions, the qualifier must be hardcoded in the procedure DDL. We are requesting that the qualifier parm apply to user defined functions and types as it applies to table schemas.