Each row contains procedure parameter specific option values.
Table 80. SYSCAT.PROCPARMOPTIONS Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
PROCSCHEMA | VARCHAR(128) |
| Qualified procedure name or nickname. |
PROCNAME | VARCHAR(128) |
| |
ORDINAL | SMALLINT |
| The parameter's numerical position within the procedure signature. |
OPTION | VARCHAR(128) |
| Name of the stored procedure option. |
SETTING | VARCHAR(255) |
| Value. |