ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 615
SQL Syntax Summary
SET TRANSACTION
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 }[,...]
SET USER TIMEOUT
SET USER TIMEOUT [TO] {{ TimeoutValue
:HostVariable } [SECONDS
MINUTES]
DEFAULT
MAXIMUM }
SQLEXPLAIN
SQLEXPLAIN : HostVariable