DBEC: Controlling Remote System Resources with Enhanced Commands › Updating Table-level Processing Options › Overriding DBURTBL Parameter Values

Overriding DBURTBL Parameter Values

You define online URTs for CICS programs using three macros: the Start macro (DBURSTR), the Entry macro (DBURTBL), and the End macro (DBUREND). Of the Entry macro (DBURTBL) parameters, you can override the following four by updating the scrollable display invoked with DBEC for the table-level URT inquiry.

Use the following guidelines to change the current setting for any of these parameter values associated with any table within any URT.

AUTODXC

Change options for AUTODXC= follow:

• Change from YES to NO to indicate that RDUxx commands are no longer to automatically drop secondary exclusive control and that the program is to release the record if it is not updated or deleted after having been read with update intent.
• Change from NO to YES to allow consecutive RDUxx commands to execute without an intervening update, delete, or release.

BYP

Change options for BYPOPEN= follow:

• Change from NO to YES to disable access to this table through this URT as of the next time this URT is opened.
• Change from YES to NO if the corresponding table is no longer to be bypassed during open and close processing.

SYN

Change options for SYNONYM= follow:

• Change from NO to YES if CA Datacom CICS Services should now evaluate the database ID specified in the Request Area together with the table name when searching for a URT to service a request for this table and if CA Datacom/DB should evaluate the DBID when searching for a macro within this URT containing processing specifications. Before specifying YES, verify that all requests to this table issued by online programs, specify the database ID in the Request Area. Make this change under either of the following conditions:
  • The table name is now duplicated in another URT (online only).
  • The table name is now duplicated in this URT (same as batch).
• Change from YES to NO if there are no duplicate names for this table in this URT or any other URT and CA Datacom/DB is not to evaluate the DBID when selecting a URT to process a request to this table, but rather, is to use the database ID specified in the first available URT containing this table name.

UPD

Change options for UPDATE= follow:

• Change from NO to YES if this table can be updated and its records held under exclusive control when accessed through this URT. UPDATE=YES is required if a program issues Compound Boolean Selection commands (SELxx), unless a DBID is specified in the CBS MUF startup option.
• Change from YES to NO to limit access of the corresponding table to read-only.