DROP PROCEDURE

The DROP PROCEDURE data description statement deletes the definition of the referenced procedure from the dictionary. For procedures with language SQL, the statement removes the SQL routine body from the dictionary and the associated entities: access module(AM), relational command module (RCM), ADS premap process code, and dialog load module.

Authorization

To issue a DROP PROCEDURE statement, you must own or have the DROP privilege on the procedure named in the statement.

Syntax

►►─── DROP PROCEDURE ───────┬──────────────────┬─ procedure-identifier ───────►
                            └── schema-name.───┘

 ►────┬───────────┬───────────────────────────────────────────────────────────►◄
      └─ CASCADE ─┘

Parameters

procedure-identifier

Specifies the name of the procedure to be dropped. Procedure-identifier must identify a procedure defined in the dictionary.

schema-name

Identifies the schema associated with the specified procedure. If you do not specify a schema-name, the default value is:

The current schema associated with your SQL session, if you specify the statement through the Command Facility or execute it dynamically
The schema associated with the access module used at runtime, if the statement is embedded in an application program

CASCADE

Directs CA IDMS to delete any view definition that contains a reference to the procedure, either directly or nested within some other view reference.

Example

The following DROP PROCEDURE statement example removes the EMP.GET_BONUS procedure from the SQL catalog.

   drop procedure emp.get_bonus cascade

More Information

For more information about syntax for creating procedures, see CREATE PROCEDURE.
For more information about defining and using procedures, see Defining and Using Procedures.
For more information about coding the external routines which process procedure references, see Defining and Using Procedures.