ALLBASE/SQL Reference Manual (36216-90216)
612 AppendixA
SQL Syntax Summary
SAVEPOINT
SAVEPOINT [:
HostVariable
:
LocalVariable
:
ProcedureParameter
]
SELECT
Select Statement Level
[BULK]
QueryExpression
[ORDER BY {
ColumnID
[ASC
DESC]}[,...]]
Subquery Level
(
QueryExpression
)
Query Expression Level
{
QueryBlock
(
QueryExpression
)}[UNION [ALL]{
QueryBlock
(
QueryExpreession
)}][...]
Query Block Level
SELECT [ALL
DISTINCT]
SelectList
[INTO
HostVariableSpecification
]
FROM
FromSpec
[,...]
[WHERE
SearchCondition1
]
[GROUP BY
GroupColumnList
]
[HAVING
SearchCondition2
]
SelectList
{*
[
Owner.
]
Table.
*
CorrelationName.*
Expression
[[
Owner.
]
Table.
]
ColumnName
CorrelationName.ColumnName
}[,...]
HostVariableSpeciļ¬cation--With BULK Option
:
Buffer
[ ,:
StartIndex
[,:
NumberOfRows
] ]
HostVariableSpeciļ¬cation--Without BULK Option
{
:HostVariable
[ [INDICATOR] :
Indicator
] ) [,...]