DB2 UDB ULW: Replacing an SQL procedure language based function used in object definitions? 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 |