TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

Chapter 5 237
TurboIMAGE/XL Library Procedures
DBXEND
DBXEND
INTRINSIC NUMBER 421
Designates the end of a sequence of TurboIMAGE/XL procedure calls regarded as a
dynamic transaction for the purposes of logging and dynamic roll-back recovery. The text
parameter can be used to log user information to the log file. DBXEND is used in conjunction
with DBXBEGIN to begin and end a dynamic transaction.
Syntax
DBXEND ,{
base
baseidlist
}
text,mode,status,textlen
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.)
baseidlist
is the name of the integer array containing the base IDs of the databases
which are involved in the DMDBX. Use the same
baseidlist
used with
DBXBEGIN when calling DBXEND mode 3 to end the DMDBX. The layout of
this array is same as in DBXBEGIN, except that the transaction ID is
already set in the first two halfwords by DBXBEGIN.
text
is an array up to 256 halfwords long that contains user ASCII or binary
data to be written to the log file as part of the DBXEND log record.
mode
must be a halfword equal to 1, 2 or 3.
Mode 1: End of dynamic transaction spanning one database.
Mode 2: End of dynamic transaction spanning one database,
started with DBXBEGIN mode 1, and write contents of the
transaction management (XM) logging buffer in memory
to disk. If logging is enabled, the contents of the logging
buffer in memory will also be written to disk.
Mode 3: Indicates the end of a DMDBX started with DBXBEGIN mode
3. If user logging is enabled for the databases, mode 3
generates multiple entries in the log file, one for each
database in the DMDBX, in order to mark the end of a
dynamic transaction.
status
is the name of an array of 10 halfwords in which TurboIMAGE/XL returns
status information about the procedure. If the procedure executes
successfully, the status array contents are as follows:
Element Contents
1 If the procedure succeeds, the return status is 0. Table