SYSROUTINES_OPTS catalog table (deprecated)
The SYSROUTINES_OPTS table Contains a row for each generated routine, such as one created by Db2 for z/OS® Procedure Processor DSNTPSMP, that records the build options for the routine. The schema is SYSIBM.
Deprecated function: 
External SQL procedures are deprecated and not as fully supported as native SQL procedures. For best results, create native SQL procedures instead. For more information, see Creating native SQL procedures and Migrating an external SQL procedure to a native SQL procedure.
External SQL procedures are deprecated and not as fully supported as native SQL procedures. For best results, create native SQL procedures instead. For more information, see Creating native SQL procedures and Migrating an external SQL procedure to a native SQL procedure.Rows in this table can be inserted, updated, and deleted.
| Column name | Data type | Description | Use |
|---|---|---|---|
| SCHEMA | VARCHAR(128)
NOT NULL |
Schema of the routine. | G |
| ROUTINENAME | VARCHAR(128)
NOT NULL |
Name of the routine. | G |
| BUILDDATE | DATE
NOT NULL WITH DEFAULT |
Date the routine was built. | G |
| BUILDTIME | TIME
NOT NULL WITH DEFAULT |
Time the routine was built. | G |
| BUILDSTATUS | CHAR(1)
NOT NULL WITH DEFAULT 'C' |
Whether this version of the routine's options is the current version. | G |
| BUILDSCHEMA | VARCHAR(128)
NOT NULL |
Schema name for BUILDNAME. | G |
| BUILDNAME | VARCHAR(128)
NOT NULL |
Procedure used to create the routine. | G |
| BUILDOWNER | VARCHAR(128)
NOT NULL |
Authorization ID used to create the routine. | G |
| IBMREQD | CHAR(1)
NOT NULL WITH DEFAULT 'N' |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. |
G |
| PRECOMPILE_OPTS | VARCHAR(765)
NOT NULL WITH DEFAULT |
SQL processing (precompiler or coprocessor) options used to build the routine. | G |
| COMPILE_OPTS | VARCHAR(765)
NOT NULL WITH DEFAULT |
Compiler options used to build the routine. | G |
| PRELINK_OPTS | VARCHAR(765)
NOT NULL WITH DEFAULT |
Prelink-edit options used to build the routine. | G |
| LINK_OPTS | VARCHAR(765)
NOT NULL WITH DEFAULT |
Link-edit options used to build the routine. | G |
| BIND_OPTS | VARCHAR(3072)
NOT NULL WITH DEFAULT |
Bind options used to build the routine. | G |
| SOURCEDSN | VARCHAR(765)
NOT NULL WITH DEFAULT |
Name of the source data set. | G |
| DEBUG_MODE | CHAR(1) NOT NULL
|
Debugging is on or off for this object.
|
G |