By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
If you want to rebind procedure package:

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

-- Artur Wronski

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.