I am developing an application in DB2 with SQL PL, and the routines (procedures and functions) are being defined in a module.
However, each time I change a routine, I cannot replace it, and I have to drop the module body, and recreate it.
Is there any way to do a REPLACE for a routine inside a module?
ALTER MODULE mod PUBLISH PROCEDURE p1 (); ALTER MODULE mod ADD PROCEDURE p1 () BEGIN ... END; ALTER MODULE mod REPLACE PROCEDURE p1 () -- This is the useful option. BEGIN ... END;