A tabela SYSROUTINES_OPTS Contém uma linha para cada rotina gerada, como aquela criada pelo Db2 for z/OS® Procedure Processor DSNTPSMP, que registra as opções de
construção para a rotina.
O esquema é SYSIBM.
Função obsoleta:
os procedimentos SQL externos estão obsoletos e não são totalmente suportados como os procedimentos SQL nativos.
Para obter melhores resultados, crie procedimentos SQL nativos.
As linhas nesta tabela podem ser inseridas, atualizadas e excluídas.
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.
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 came from the basic machine-readable material (MRM) tape.
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.
- 0
- Debugging is off.
Default and value on migration are both 0.
- 1
- Debugging is on.
|
G |
