FUNCTIONS

SCHEMANAME

CHAR(32)

Name of the schema of the database function

FUNCTION NAME

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)

DETERMI NI STIC

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