Contains a row for every parameter or result of a function or method
defined in SYSCAT.FUNCTIONS.
Table 61. SYSCAT.FUNCPARMS Catalog View
| Column Name | Data Type | Nullable | Description | ||
|---|---|---|---|---|---|
| FUNCSCHEMA | VARCHAR(128) |
| Qualified function name. | ||
| FUNCNAME | VARCHAR(18) |
| |||
| SPECIFICNAME | VARCHAR(18) |
| The name of the function instance (may be system-generated). | ||
| ROWTYPE | CHAR(1) |
|
| ||
| ORDINAL | SMALLINT |
| If ROWTYPE = P, the parameter's numerical position within the function signature. If ROWTYPE = R and the function returns a table, the column's numerical position within the result table. Otherwise 0. | ||
| PARMNAME | VARCHAR(128) |
| Name of parameter or result column, or null if no name exists. | ||
| TYPESCHEMA | VARCHAR(128) |
| 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) |
|
| ||
| TARGET_TYPESCHEMA | VARCHAR(128) |
| 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 | VARCHAR(128) |
| 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(128) |
| |||
| TRANSFORM_GRPNAME | VARCHAR(18) | Yes | Name of transform group for a structured type function parameter. | ||
| |||||