Contains a row for each parameter of a stored procedure.
Table 83. SYSCAT.PROCPARMS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PROCSCHEMA | CHAR(8) |
| Qualified procedure name. |
| PROCNAME | VARCHAR(18) |
| |
| SPECIFICNAME | VARCHAR(18) |
| The name of the procedure instance (may be system generated). |
| ORDINAL | SMALLINT |
| The parameter's numerical position within the procedure signature. |
| PARMNAME | VARCHAR(18) |
| Parameter name. |
| TYPESCHEMA | CHAR(8) |
| Qualified name of data type of the parameter. |
| TYPENAME | VARCHAR(18) |
| |
| LENGTH | INTEGER |
| Length of the parameter. |
| SCALE | SMALLINT |
| Scale of the parameter. |
| CODEPAGE | SMALLINT |
| Code page of parameter. 0 denotes either not applicable or a parameter for character data declared with the FOR BIT DATA attribute. |
| PARM_MODE | VARCHAR(5) |
| IN=Input, OUT=Output, INOUT=Input/output |
| AS_LOCATOR | CHAR(1) |
| Always 'N' |