ALLBASE/SQL Reference Manual (36216-90216)

614 AppendixA
SQL Syntax Summary
Scan Access
[NO]{SERIALSCAN
INDEXSCAN
HASHSCAN
SORTINDEX }
Join Algorithm
[NO] {NESTEDLOOP
NLJ
SORTMERGE
SMJ }
SET PRINTRULES
SET PRINTRULES [ON
OFF]
SET SESSION
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 }[,...]