Contains a row for every parameter or result of a function defined in
OBJCAT.FUNCTIONS.
Table 107. OBJCAT.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. | ||
| TARGET_TYPESCHEMA | CHAR(8) |
| Qualified name of the target type, if the type of the parameter or result is REFERENCE. Null value if the type of the parameter or result is not REFERENCE. | ||
| TARGET_TYPENAME | VARCHAR(18) |
| |||
| SCOPE_TABSCHEMA | CHAR(8) |
| Qualified name of the scope (target table), if the type of the parameter or result is REFERENCE. Null value if the type of the parameter or result is not REFERENCE or the scope is not defined. | ||
| SCOPE_TABNAME | VARCHAR(18) |
| |||
| 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.
| ||
| |||||