The SQLFUNCTIONCOLS view contains one row for every parameter of a function. The result of a scalar function and the result columns of a table function are also returned.
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) | Schema name of the function instance. |
| FUNCTION_NAME | VARCHAR(128) | Name of the function instance. |
| COLUMN_NAME | VARCHAR(128) Nullable |
Name of a function parameter. Contains the null value if the parameter does not have a name. |
| COLUMN_TYPE | SMALLINT | Type of the parameter:
|
| DATA_TYPE | SMALLINT | The data type of the parameter:
|
| TYPE_NAME | VARCHAR(261) | The name of the data type of the
parameter:
|
| COLUMN_SIZE | INTEGER | Length of the parameter. |
| BUFFER_LENGTH | INTEGER | Indicates the length of the parameter in a buffer. |
| DECIMAL_DIGITS | SMALLINT Nullable |
Scale of numeric or datetime data.
Contains the null value if the parameter is not decimal, numeric, binary, time or timestamp. |
| NUM_PREC_RADIX | SMALLINT Nullable |
Indicates if the precision specified
in column NUMERIC_PRECISION is specified as a number of binary or
decimal digits:
Contains the null value if the parameter is not numeric. |
| NULLABLE | SMALLINT | Indicates whether the parameter is
nullable.
|
| REMARKS | VARGRAPHIC(2000) CCSID
1200Nullable ![]() |
A character string supplied with
the COMMENT statement. Contains the null value if there is no long comment. |
| COLUMN_DEF | VARCHAR(1) Nullable |
The default value for the column.
Contains the null value if there is no default value. |
| SQL_DATA_TYPE | SMALLINT | The SQL data type of the parameter:
|
| SQL_DATETIME_SUB | SMALLINT Nullable |
The datetime subtype of the parameter:
Contains the null value if the data type is not a datetime data type. |
| CHAR_OCTET_LENGTH | INTEGER Nullable |
Indicates the length in characters
of the parameter. Contains the null value if the column is not a string. |
| ORDINAL_POSITION | INTEGER | Numeric place of the parameter in
the parameter list, ordered from left to right. For scalar functions, the result of the function has a value of 0. For table functions, the result columns are numbered from 1 (leftmost result column) to n (nth result column). |
| IS_NULLABLE | VARCHAR(3) | Indicates whether the parameter is
nullable.
|
| SPECIFIC_NAME | VARCHAR(128) | Specific name of the function instance |
| JDBC_DATA_TYPE | INTEGER | The JDBC data type of the parameter:
|
| I_DATA_TYPE | INTEGER | Indicates the IBM® i CLI data type of the parameter.
|