SYSCAT.ROUTINEOPTIONS catalog view
Each row represents a routine-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. | |
| ROUTINEMODULENAME | VARCHAR (128) | Unqualified name of the module to which the routine belongs. The null value if not a module routine. | |
| ROUTINENAME | VARCHAR (128) | Unqualified name of the routine. | |
| SPECIFICNAME | VARCHAR (128) | Name of the routine instance (might be system-generated). | |
| OPTION | VARCHAR (128) | Federated routine option name or routine environment variable name. | |
| SETTING | VARCHAR (2048) | Federated routine option value or routine environment variable value. |