HP 3000 Manuals

Definition [ HP IMAGE/SQL Administration Guide ] MPE/iX 5.0 Documentation


HP IMAGE/SQL Administration Guide

Definition 
[REV BEG]

A transaction is a unit of work consisting of one or more SQL statements
referencing one or more databases in a DBEnvironment.  Work done within a
transaction can be committed (made permanent) or undone (rolled back).  A
transaction is started with an implicit or explicit BEGIN WORK statement
and is either committed with COMMIT WORK or rolled back with ROLLBACK
WORK.

An IMAGE/SQL transaction is started by the first SQL statement that
results in a modification or repeatable read of an IMAGE/SQL table.[REV
END]



MPE/iX 5.0 Documentation