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.
idmscu19
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