I am porting a big application from Oracle 8i to DB2 8.2 for Linux and we have more than 300 stored procedures and functions to port. Among some normal problems, we are facing a big one.

As we need to change procedures and UDFs a lot of times, we have to drop these objects and create them again (in Oracle there is a "create or replace procedure" option). But, in order to drop a procedure, we need to drop all the dependent objects. If one UDF has 30 dependencies, we'll have to drop all of them and create them again. It's a lot of work...

If it's right, we are going to have more problems, because this will impact in loosing access to these objects (GRANTs) and we'll have to grant all the privileges in all these procedures again.

Is there a solution to this situation?