Procedures (PL/SQL)

The DB2® data server supports the compilation and execution of PL/SQL procedures. PL/SQL procedures are database objects that contain PL/SQL procedural logic and SQL statements that can be invoked in contexts where the CALL statement or procedure references are valid.

PL/SQL procedures are created by executing the PL/SQL CREATE PROCEDURE statement. Such procedures can be dropped from the database by using the DB2 SQL DROP statement. If you want to replace the implementation for a procedure, you do not need to drop it. You can use the CREATE PROCEDURE statement and specify the OR REPLACE option to replace the procedure implementation.