Contains a row for each parameter of a stored procedure.
Table 101. SYSCAT.PROCPARMS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PROCSCHEMA | VARCHAR(128) |
| Qualified procedure name. |
| PROCNAME | VARCHAR(128) |
| |
| SPECIFICNAME | VARCHAR(18) |
| The name of the procedure instance (may be system generated). |
| SERVERNAME | VARCHAR(128) | Yes | Name of the data source on which the stored procedure resides. |
| ORDINAL | SMALLINT |
| The parameter's numerical position within the procedure signature. |
| PARMNAME | VARCHAR(18) |
| Parameter name. |
| TYPESCHEMA | VARCHAR(128) |
| Qualified name of data type of the parameter. |
| TYPENAME | VARCHAR(18) |
| |
| TYPEID | SMALLINT | Yes | Internal type ID. |
| SOURCETYPEID | SMALLINT | Yes | Internal type ID of source type. Null for built-in types. |
| NULLS | CHAR(1) |
| federated database nullable rule:
|
| LENGTH | INTEGER |
| Length of the parameter. |
| SCALE | SMALLINT |
| Scale of the parameter. |
| PARM_MODE | VARCHAR(5) |
|
|
| CODEPAGE | SMALLINT |
| Code page of parameter. 0 denotes either not applicable or a parameter for character data declared with the FOR BIT DATA attribute. |
| DBCS_CODEPAGE | SMALLINT | Yes | DBCS codepage. Null for numeric fields. |
| AS_LOCATOR | CHAR(1) |
| Always 'N' |
| TARGET_TYPESCHEMA | VARCHAR(128) | Yes | If type of parameter is reference then contains qualified name of target rowtype. Null otherwise. |
| TARGET_TYPENAME | VARCHAR(18) | ||
| SCOPE_TABSCHEMA | VARCHAR(128) | Yes | If type of parameter is reference then contains qualified name of scope (target table). Null otherwise. |
| SCOPE_TABNAME | VARCHAR(128) |