ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 613
SQL Syntax Summary
FromSpec
{ TableSpec
( FromSpec )
FromSpec NATURAL [INNER
LEFT [OUTER]
RIGHT [OUTER]] JOIN { TableSpec
( FromSpec ) }
FromSpec [INNER
LEFT [OUTER]
RIGHT [OUTER]] JOIN { TableSpec
( FromSpec )}{ON SearchCondition3
USING ( ColumnList ) } }
TableSpec
[
Owner .] TableName [ CorrelationName ]
SET CONNECTION
SET CONNECTION { ‘ConnectionName’
:HostVariable }
SET CONSTRAINTS
SET ConstraintType [,...]CONSTRAINTS {DEFERRED
IMMEDIATE}
SET DEFAULT DBEFILESET
SET DEFAULT {SECTIONSPACE
TABLESPACE } TO DBEFILESET DBEFileSetName FOR PUBLIC
SET DML ATOMICITY
SET DML ATOMICITY AT {ROW
STATEMENT} LEVEL
SET MULTITRANSACTION
SET MULTITRANSACTION {ON
OFF}
SETOPT
SETOPT {CLEAR
GENERAL { ScanAccess
JoinAlgorithm }[,...]
BEGIN {GENERAL { ScanAccess
JoinAlgorithm } } [,...]END }