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

DB2 UDB ULW: Replacing an SQL procedure language based function used in object definitions?

P: n/a
When a Function returning a scalar is written in C, it is easy to
change the code, by just creating a new loadable object.

When the code is written in SQL procedure language, how to replace the
code when there are dependencies? The restrict is default in drop
function, there is no no-restrict capability.

Remark: was already posten in the newsgroups, concerning dependencies
on triggers. Suggestion was to drop and recreate the triggers. What if
the dependency impacts ... tables?

Bernard Dhooghe

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


P: n/a
Bernard Dhooghe wrote:
When a Function returning a scalar is written in C, it is easy to
change the code, by just creating a new loadable object.

When the code is written in SQL procedure language, how to replace the
code when there are dependencies? The restrict is default in drop
function, there is no no-restrict capability.

Remark: was already posten in the newsgroups, concerning dependencies
on triggers. Suggestion was to drop and recreate the triggers. What if
the dependency impacts ... tables?

Bernard Dhooghe

You will need to unravel the dependencies and recreate the objcets
afterwards.
There is a function DB2LK_DEP_OF() which you can use to get the
dependencies sorted out.

Long term expect DB2 to introduce "invalid" states for all objects which
can be revalidated on first use.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
Thank you Serge.

I'll put it on my long-term-hope pile.

Bernard Dhooghe

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.