ALLBASE/SQL Reference Manual (36216-90216)

608 AppendixA
SQL Syntax Summary
Grant DBEFileSet Authority
GRANT {SECTIONSPACE
TABLESPACE } [,...] ON DBEFILESET DBEFileSetName TO
{ DBEUserID
GroupName
ClassName
PUBLIC } [,...]
IF
IF Condition THEN [ Statement ;[...]]
[ELSEIF Condition THEN [ Statement ; [...]]]
[ELSE [ Statement ; [...]]] ENDIF;
INCLUDE
INCLUDE {SQLCA [[IS]EXTERNAL]
SQLDA }
INSERT - 1
[BULK]INSERT INTO { [ Owner. ] TableName
[ Owner. ] ViewName }
[({ ColumnName }[,...])]
VALUES ({ SingleRowValues
BulkValues
? })
SingleRowValues
{NULL
USER
: HostVariable [ [INDICATOR]: IndicatorVariable ]
?
: LocalVariable
:ProcedureParameter
:: Built-inVariable
ConversionFunction
CurrentFunction
[+
-]{ Integer
Float
Decimal }
‘ CharacterString ’
OxHexadeciamalString
‘ LongColumnIOString ’ }[,...]