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. |