Object documentationFUNCTIONS Locate this document in the navigation structure

 

The system table DOMAIN.FUNCTIONS contains all the database functions for which the current user has privileges.

Structure

FUNCTIONS

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

More Information

Evaluating System Tables, FUNCTIONS

SQL Reference Manual, Name of a Database Function (dbfunction_name)