DBOC: Controlling Local Resources with Operational Commands › DISABLE= Bypassing Table Opening

DISABLE= Bypassing Table Opening

When a URT is opened, every table listed in it is opened unless it has BYPOPEN=YES specified in its DBURTBL macro. For more information, see the CA Datacom/DB Database and System Administration Guide. The DISABLE= command suppresses the opening of a specified table listed in a URT when that URT is opened. The ENABLE= command resets a table so that CA Datacom/DB opens it when the URT naming it is opened. When a request references a disabled table contained in an open URT, it receives a CA Datacom/DB return code of 05.

The URT containing the tables to disable must be closed when this transaction is issued. Before issuing this command, verify that the URT is closed or invoke the transaction to close it. For more information, see CLOSE=: Closing URTs.

Use the following format to disable the opening of a table:

►►─ DBOC ─ DISABLE= ─┬────────┬─ table ─┬─────────┬───────────────────────────►◄
                     └─ urt. ─┘         └─ .dbid ─┘

DBOC

(Required) Specify the transaction ID used with Operational commands to control system resources. Leave a space between the transaction ID and the command.

DISABLE=

(Required) Indicates to bypass the tables from opening when the URT is opened.

urt.

(Required) Identifies by number one or more URTs. Separate from the table name with a period (urt.table). To specify acceptance of any value, 1—9, in one or more places within the URT name, use the wildcard symbol (?). To specify multiple URTs individually, separate members within the series with commas.

table

(Required) Identifies the table or tables to which the command applies. Use the wildcard symbol (?) in the first, second, or third place of the three-character table name to accept any valid character in that place. This form of DISABLE requires that it is qualified first by the URT field, either a specific URT number or a wildcard set of URTs. Use a period as a separator between URT number and the table name (urt.table).

.dbid

(Optional) Used with a table name to limit the command action to that table within the specified database. Use a period as a separator between table name and the five-digit database ID (urt.table.dbid). To apply the named command to the listed tables in database IDs within a known range, use the wildcard symbol (?). To apply the named command to the listed tables in all databases, either omit the database ID from the operand or specify ????? for the dbid. To use the dbid option requires that both urt and table fields be present prior to the DBID field.