ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 315
SQL Statements A - D
BEGIN WORK
2. BEGIN WORK and set attributes
Begin the transaction and set priority, isolation level, label name, and fill option:
BEGIN WORK 32 CS LABEL 'xact1' FILL
.
.
.
Execute SQL statements.
.
.
.
Work is committed and the transaction ends.
COMMIT WORK
Begin another transaction and set priority, isolation level, and label name. Note that
since a fill option is not specified, the default (NO FILL) is in effect.
BEGIN WORK 64 RC LABEL 'xact2'
.
.
.
Execute SQL statements.
.
.
.
Work is committed and the transaction ends.
COMMIT WORK;