Contains a row for every parameter or result of a function defined in
SYSCAT.FUNCTIONS.
Table 47. SYSCAT.FUNCPARMS Catalog View
| Column Name | Data Type | Nullable | Description | ||
|---|---|---|---|---|---|
| FUNCSCHEMA | CHAR(8) |
| Qualified function name. | ||
| FUNCNAME | VARCHAR(18) |
| |||
| SPECIFICNAME | VARCHAR(18) |
| The name of the function instance (may be system-generated). | ||
| ROWTYPE | CHAR(1) |
|
P=parameter R=result before casting C=result after casting | ||
| ORDINAL | SMALLINT |
| If ROWTYPE=P, the parameter's numerical position within the function signature. Otherwise 0. | ||
| PARMNAME | VARCHAR(18) |
| Name of parameter or result column, or null if no name exists. | ||
| TYPESCHEMA | CHAR(8) |
| Qualified name of data type of parameter or result. | ||
| TYPENAME | VARCHAR(18) |
| |||
| LENGTH | INTEGER |
| Length of parameter or result. 0 if parameter or result is a distinct type. See Note 1. | ||
| SCALE | SMALLINT |
| Scale of parameter or result. 0 if parameter or result is a distinct type. See Note 1. | ||
| CODEPAGE | SMALLINT |
| Code page of parameter. 0 denotes either not applicable or a column for character data declared with the FOR BIT DATA attribute. | ||
| CAST_FUNCID | INTEGER | Yes | Internal function ID. | ||
| AS_LOCATOR | CHAR(1) |
|
Y=Parameter or result is passed in
the form of a locator
N=Not passed in the form of a locator.
| ||
| |||||