HP 3000 Manuals HP 3000 Manuals
BEGIN TRANSACTION
The BEGIN TRANSACTION statement defines the beginning of a sequence of
TurboIMAGE procedure calls that are to be regarded as a single logical
transaction for the purposes of logging and recovery. The MSG parameter
allows you to log additional information in the log file. TurboIMAGE
logs database transactions on the transaction log file if any of the
following are true:
* The database is open in one of the following modes:
* Modify with enforced locking.
* Update.
* Exclusive modify.
* Modify.
* The database is enabled for logging by the database administrator.
* The system console has enabled a logging process.
The transaction log file is explained in the TurboIMAGE/XL Database
Management System.
Syntax
BEGIN TRANSACTION dbname$, MSG[=]str_expr, [, STATUS[=]status_array(*)]
Parameters
dbname$ A string variable, whose value is a TurboIMAGE database
name. This must be the dbname$ returned by a successful
DBOPEN statement.
str_expr A string of ASCII characters of up to 512 characters in
length to be written as part of the BEGIN TRANSACTION
log record.
status_array A 10-element short integer array to which TurboIMAGE
returns any error codes or other status information. If
an HP Business BASIC/XL database statement specifies the
STATUS option, an error does not abort the program.
Following execution of the database statement the
program can check status_array and handle the error.
The values returned by TurboIMAGE to this array are
detailed in the description of the status parameter of
the equivalent TurboIMAGE library procedure.
Examples
The following shows the use of the BEGIN TRANSACTION statement.
100 BEGIN TRANSACTION Db$,MSG=Message$,STATUS=S(*)
110 BEGIN TRANSACTION Db$,MSG Message$,STATUS S(*)