TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)
146 Chapter5
TurboIMAGE/XL Library Procedures
DBCONTROL
DBCONTROL
INTRINSIC NUMBER 411
Allows a process accessing the database to have control over some DBUTIL options. In
exclusive mode (DBOPEN mode 3), DBCONTROL can be used to enable or disable the deferred
output (AUTODEFER) option and perform several B-Tree related tasks such as adding,
dropping, or rebuilding a B-Tree index. It can also be used to set BTREEMODE1 option to ON
or OFF and specify the wildcard character for the current DBOPEN or for the database
(permanent).
For database access modes 1, 3, and 4, DBCONTROL can be used to temporarily enable or
disable the critical item update (CIUPDATE) option, depending on the setting for the
database, without impacting other processes operating on the same database. Using
DBCONTROL does not alter the permanent AUTODEFER or CIUPDATE settings for the database
set with DBUTIL. However, the permanent setting for BTREEMODE1 and wildcard character
can be altered based on the DBCONTROL mode.
Syntax
DBCONTROL,
base,qualifier,mode,status
Parameters
base
is the name of the array used as the base parameter when opening the
database. The first element of the array must contain the base ID returned
by DBOPEN. (Refer to DBOPEN for more information about the base ID.)
qualifier
used only for certain DBCONTROL modes.
mode
must be an integer equal to 1, 2, 5, 6, 7, 9, 10, 13, 14, 15, or 16 indicating
the following:
Mode 1: Turn on the deferred output option. If AUTODEFER has not
been enabled for the database (using DBUTIL >>ENABLE),
mode 1 enables the deferred output option for the duration
of only the current DBOPEN. When the database is closed,
AUTODEFER will no longer be enabled. Mode 1 is not
allowed while a dynamic transaction is active.
Mode 2: Turn off the deferred output option. If AUTODEFER has
been enabled for the database (using DBUTIL >>ENABLE),
mode 2 disables the deferred output option for the
duration of only the current DBOPEN. When the database is
closed, AUTODEFER will again be enabled.
Mode 5: Enable the critical item update option. If CIUPDATE is
ALLOWED for the database (default or by using DBUTIL
>>SET), mode 5 enables the option for the current DBOPEN
until either a DBCONTROL mode 6 call disables the option