SYSCAT.ROUTINEPARMOPTIONS catalog view
Each row represents a routine parameter-specific option value.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| ROUTINESCHEMA | VARCHAR (128) | Schema name of the routine if ROUTINEMODULEID is null; otherwise schema name of the module to which the routine belongs. | |
| ROUTINENAME | VARCHAR (128) | Unqualified name of the routine. | |
| SPECIFICNAME | VARCHAR (128) | Name of the routine instance (might be system-generated). | |
| ORDINAL | SMALLINT | Position of the parameter within the routine signature. | |
| OPTION | VARCHAR (128) | Name of the federated routine option. | |
| SETTING | VARCHAR (2048) | Value of the federated routine option. |