ALLBASE/SQL Reference Manual (36216-90216)

536 Chapter12
SQL Statements S - Z
SET SESSION
SET SESSION
The SET SESSION statement sets one or more transaction attributes for the duration of a
session to be applied to the next and subsequent transactions. These attributes include:
isolation level, priority, user label, constraint checking mode, DML atomicity level, timeout
rollback, user timeout, termination level, and fill options.
Scope
ISQL or Application Programs
SQL Syntax
SET SESSION {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
[{PARALLEL
NO }]FILL }[,...]
Parameters
RR Repeatable Read. Means that the transaction uses locking strategies to
guarantee repeatable reads.
RR is the default isolation level.