how to drop a procedure/function without dropping the dependencies
Posted on 2011-03-09
I'm on Db2 UDB 8.2
I have a fucntion, which is calling a stored procedure inside it.
I made changes to the function and tried to compile it, when it said, it cannot drop it as it has a dependency as the stored procedure. Soon i realized that there are a number of other functions that use this function and so, they all depend on this function.
I'm not changing any of the dependencies. Can i force drop this function and re-create it without dropping all the dependencies?