DROP PROCEDURE
MPE documents | |
 Complete PDF | |
| Table of Contents | |
| Index | |
| E0300 Edition 9 ♥ | |
| E0399 Edition 8 | |
| E0897 Edition 7 |
Scope
ISQL or Application Programs
SQL Syntax
DROP PROCEDURE [Owner.]ProcedureName [PRESERVE]
Parameters
- [Owner.]ProcedureName
specifies the name of the procedure that is to be dropped.
- PRESERVE
specifies that EXECUTE authorities associated with the procedure should be retained in the system catalog.
Description
If you do not specify PRESERVE, the EXECUTE authorities associated with the procedure are removed.
If a rule attempts to execute a procedure that has been dropped, the rule will fail and all the effects of the statement that fired the rule are undone.
The DROP PROCEDURE statement does not drop rules that invoke the procedure. All rules invoking the procedure are preserved.
The DROP PROCEDURE statement will invalidate stored sections that depend on invoking the procedure from a rule. The loss of the procedure will be reported as an error when there is an attempt to revalidate these sections.
Authorization
You must be the owner of the procedure or have DBA authority to use the DROP PROCEDURE statement.
Example
DROP PROCEDURE Process12 PRESERVE
|
DROP PARTITION |
DROP RULE |