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.

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

For more information about syntax for creating functions, see CREATE FUNCTION.
For more information about using functions, see Expansion of User-defined-function.
For more information about coding the external routines which process function invocations, see Defining and Using Functions.