The system table DOMAIN.FUNCTIONS contains all the database functions for which the current user has privileges.
SCHEMANAME |
CHAR(32) |
Name of the schema of the database function |
FUNCTIONNAME |
CHAR(32) |
Name of the database function |
OWNER |
CHAR(32) |
Name of the owner of the database function |
FUNCTIONID |
CHAR(8) |
ID of the database function in hexadecimal format |
PARAMETER |
FIXED(4) |
Number of parameters for the database function |
CREATEDATE |
DATE |
Creation data of the database function |
CREATETIME |
TIME |
Creation time of the database function |
EXECUTION_KIND |
CHAR(10) |
Execution location of database function (INPROC | LOCAL) |
SQL_SUPPORT |
CHAR(3) |
Database function may contain SQL statements (YES | NO) |
DETERMINISTIC |
CHAR(3) |
Database function can be deterministic (YES | NO) |
DEFINITION |
CLOB |
SQL statement for defining the database function |
COMMENT |
CLOB |
Comment on the database function |
Evaluating System Tables, FUNCTIONS
SQL Reference Manual, Name of a Database Function (dbfunction_name)