SWITCHES—Status Switches

The Status Switches are a series of one-byte codes for altering the operation of the Application Programming Interface used by your programs when requesting a tableBASE service. Switches are specified as a string of Y’s and N’s; for example: YYYNYNNN. A value in any of the eight positions represents a change for that override. A * or blank in any of the eight positions represents no change for that override. For information about switch settings, see Table 86.

The switches are stored in the parameter module for the interface. As each batch job or online task begins, the run-time values will be set according to the values in the parameter module but may be changed using the values in the TBOPT file. For more information, see Parameters in the MVS Batch section of the tableBASE Installation Guide.

The application also may change the values with the CS, the Change Status command (unless changing a particular switch is suppressed via the override controls).

The defaults for these values depend upon the interface and are described in the tableBASE Installation Guide in the appropriate chapter:

  • tableBASE MVS batch
  • CICS Interface product
  • IMS TM Interface product
  • DB2 Stored Procedure Interface product.
Table 86. Switches default values
Position Description Switch setting Meaning
1 Abend on Errors Y Abend
processing is to be performed on tableBASE errors 0001-0099 or 1001-1099.
Errors 100 to 999 and errors greater than 1099 always abend.
N Abend processing is not to be performed on tableBASE errors 0001-0099 or 1001-1099.
User programs could handle these return codes.
2 Wait for Enqueued Table Y tableBASE is to wait for tables that are
enqueued.
N tableBASE is not to wait for such enqueued tables. In this case tableBASE will
terminate with a user 0072 abend if abend processing is enabled, or, will return an error code of 0072: TABLE UNAVAILABLE;
NO WAIT in the command area if abend processing has been disabled.
Note:
Waiting in an online environment is normally discouraged. In CICS and IMS, the default is set to N.
3 Return Empty Rows in Hash Tables Y tableBASE is to return empty rows for hash
tables.
N tableBASE is to suppress the return of
empty rows for hash tables.
4 Allow Implicit Open Of Tables Y tableBASE is to automatically open tables
for read on first access.
N tableBASE is to suppress automatic opens;
an explicit open command, OR, OW, or IA must be issued to
open a table.
Note:
We recommend setting Allow Implicit Open of Tables to N, especially in multi-user environments. This gives better control over which tables are opened.
5 Trace tableBASE Commands Y tableBASE automatically records the last ten commands executed per thread.
This is done for diagnostic purposes. Contact DKL for more information.
N tableBASE does not trace commands.
6 Reserved for future use; specify as N.
7 Reserved for future use; specify as N.
8 Reserved for future use; specify as N.

The values set by this option apply to this region’s users, regardless of which TSR they access.

This option can be specified for all except the VTS Interface.