ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 609
SQL Syntax Summary
LongColumnIOString
<{[ PathName /] FileName
% SharedMemoryAddress }
[{>
>>
>!}[ PathName /]{ FileName
CharSting$
CharString$ CharString }
>%{ SharedMemoryAddress
$ }]
BulkValues
:
Buffer [ ,: StartIndex [, : NumberOfRows ] ]
Dynamic Parameter Substitution
(? [,...] )
INSERT - 2
INSERT INTO {[ Owner. ] TableName
[ Owner. ] ViewName }[( ColumnName [,...])] QueryExpression
Labeled Statement
Label : Statement
LOCK TABLE
LOCK TABLE [ Owner. ] TableName IN {SHARE [UPDATE]
EXCLUSIVE }MODE
LOG COMMENT
LOG COMMENT { ‘String’
:HostVariable
:ProcedureParameter
:ProcedureLocalVariable
?}
OPEN
OPEN CursorName [KEEP CURSOR [WITH LOCKS
WITH NOLOCKS]]
[USING { [SQL]DESCRIPTOR {SQLDA
AreaName }
HostVariableName [[INDICATOR]: IndicatorVariable ][,...]} ]