DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.ROUTINEOPTIONS catalog view

Each row represents a routine-specific option value.

Table 1. SYSCAT.ROUTINEOPTIONS Catalog View
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).
OPTION VARCHAR (128)   Name of the federated routine option.
SETTING VARCHAR (2048)   Value of the federated routine option.