Rebind of Stored Procedures in response to a Table Drop/Create

[alex.mcshane]

Overview
There are occasions when UDB Tables will have to be Dropped and
Re-Created.
For unaltered Stored Procedures, this should not necessitate a
Recompile (i.e. Re-Registration) of the SP as the SQL has not been
changed. All SPs are SQL/PL and have been developed using SPB.

Query
For DB2 on OS/390, a 'Script" of Rebind commands can be executed
against impacted Packages via a Job. (i.e. the programs do not have to
be recompiled)

Do you know if an analogus Bind mechanism exists for Re-Binding SPs
within UDB for LUW (e.g. Script via Command Window).
It seems unnecessary to have to Re-Build all SPs via SPB in response to
a Table Drop/Create.

Thanks

Alex

[Jan M. Nelken]

al**********@btinternet.com wrote:

Overview
There are occasions when UDB Tables will have to be Dropped and
Re-Created.
For unaltered Stored Procedures, this should not necessitate a
Recompile (i.e. Re-Registration) of the SP as the SQL has not been
changed. All SPs are SQL/PL and have been developed using SPB.

Query
For DB2 on OS/390, a 'Script" of Rebind commands can be executed
against impacted Packages via a Job. (i.e. the programs do not have to
be recompiled)

Do you know if an analogus Bind mechanism exists for Re-Binding SPs
within UDB for LUW (e.g. Script via Command Window).
It seems unnecessary to have to Re-Build all SPs via SPB in response to
a Table Drop/Create.

Thanks

Alex

Search online documentation available at:

http://publib.boulder.ibm.com/infoce...help/index.jsp

for rebind command.

Jan M. Nelken

[Artur]

If you want to rebind procedure package:

CALL SYSPROC.REBIND_ROUTINE_PACKAGE
('P', 'MYSCHEMA.MYPROC', 'CONSERVATIVE')

-- Artur Wronski