DROP FUNCTION

The DROP FUNCTION data description statement deletes the definition of the referenced function from the dictionary. For functions 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 FUNCTION data description statement deletes the definition of the referenced function from the dictionary. For functions 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 FUNCTION statement, you must own or have the DROP privilege on the function named in the statement.
Syntax
  ►►─── DROP FUNCTION ┬───────────────┬─
function-identifier
 ────────────────────►                     └─ 
schema-name
. ┘ ►───────┬───────────────┬─────────────────────────────────────────────────────►◄         └── CASCADE ────┘  
Parameters
  • function-identifier
    Specifies the name of the function to be dropped. Function-identifier must identify a function defined in the dictionary.
  • schema-name
    Identifies the schema associated with the specified function.
    If you do not specify a
    schema-name
    , the default value is:
    • The current schema associated with your SQL session, if the statement is entered through the Command Facility or executed 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 function, either directly or nested within some other view reference.
Example
The following DROP FUNCTION statement removes the FIN.UDF_FUNBONUS function from the SQL catalog:
DROP FUNCTION FIN.UDF_FUNBONUS CASCADE;
More Information