Depending on the change the the UDF (parm type etc) changing it can
change function resolution etc, and thus the semantics of the
trigger...that's why db2 is complaining about the dependency. If you're
just changing an attribute of the UDF (threadsafe, not threadsafe etc),
you can get away with alter function...if not, then you might want to
use db2look to pull out the trigger ddl before you drop etc.
Fred Prose wrote:
> We have a User define Function that is invoked by many of our (100+)
> triggers. The UDF needs to change, but you can't drop it decause of
> the dependencies.
> Is there no other way other than to extract all the trigger SQL, drop
> the triggers, change the function, and then put the triggers back?
> Fred Prose