The SQLFUNCTIONS view contains one row for every function.
The following table describes the columns in the 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 | VARGRAPHIC(2000) CCSID
1200Nullable ![]() |
A character string supplied with the COMMENT statement. Contains the null value if there is no long comment. |
| FUNCTION_TYPE | SMALLINT | Type of function:
|
| SPECIFIC_NAME | VARCHAR(128) | Specific name of the function instance |