SQLFUNCTIONS

The SQLFUNCTIONS view contains one row for every function.

The following table describes the columns in the view:

Table 1. SQLFUNCTIONS view
Column Name Data Type Description
FUNCTION_CAT VARCHAR(128) Relational database name
FUNCTION_SCHEM VARCHAR(128) Name of the schema of the function instance.
FUNCTION_NAME VARCHAR(128) Name of the function.
REMARKS Start of changeVARGRAPHIC(2000) CCSID 1200

Nullable

End of change
A character string supplied with the COMMENT statement.

Contains the null value if there is no long comment.

FUNCTION_TYPE SMALLINT Type of function:
1
Column or scalar function
2
Table function
SPECIFIC_NAME VARCHAR(128) Specific name of the function instance