ALLBASE/SQL Reference Manual (36216-90216)

542 Chapter12
SQL Statements S - Z
SET TRANSACTION
SET TRANSACTION
The SET TRANSACTION statement sets one or more transaction attributes for a
transaction. These attributes include: isolation level, priority, user label, constraint
checking mode, timeout rollback, user timeout, termination level, and DML atomicity
level.
Scope
ISQL or Application Programs
SQL Syntax
SET TRANSACTION {ISOLATION LEVEL {RR
CS
RC
RU
REPEATABLE READ
SERIALIZABLE
CURSOR STABILITY
READ COMMITTED
READ UNCOMMITTED
:HostVariable1 }
PRIORITY { Priority
:HostVariable2 }
LABEL { ‘LabelString’
:HostVariable3 }
ConstraintType [,...]CONSTRAINTS {DEFERRED
IMMEDIATE}
DML ATOMICITY AT {STATEMENT
ROW }LEVEL
ON {TIMEOUT
DEADLOCK}ROLLBACK {QUERY
TRANSACTION}
USER TIMEOUT [TO] {DEFAULT
MAXIMUM
TimeoutValue [{SECONDS
MINUTES}]
:HostVariable4 [{SECONDS
MINUTES}]
TERMINATION AT {SESSION
TRANSACTION
QUERY
RESTRICTED }LEVEL }[,...]
Parameters
RR Repeatable Read. Means that the transaction uses locking strategies to
guarantee repeatable reads. RR is the default isolation level.
CS Cursor Stability. Means that your transaction uses locking strategies to
assure cursor-level stability only.