ALLBASE/SQL Reference Manual (36216-90216)

604 AppendixA
SQL Syntax Summary
CREATE VIEW
CREATE VIEW [ Owner. ] ViewName [( ColumnName [,...])]
AS QueryExpression [IN DBEFileSetName ]
[WITH CHECK OPTION [CONSTRAINT ConstraintID ]]
DECLARE CURSOR
DECLARE CursorName [IN DBEFileSetName ] CURSOR FOR
{ { QueryExpression
SelectStatementName }[FOR UPDATE OF { ColumnName }[,...]
FOR READ ONLY ]
ExecuteProcedureStatement
ExecuteStatementName }
DECLARE Variable
DECLARE { LocalVariable }[,...] VariableType {LANG = VariableLangName ]
[DEFAULT { Constant
NULL
CurrentFunction }][NOT NULL]
DELETE
DELETE [WITH AUTOCOMMIT]FROM {[ Owner. ] TableName
[ Owner. ] ViewName } [WHERE SearchCondition ]
DELETE WHERE CURRENT
DELETE FROM {[ Owner. ] TableName
[ Owner. ] ViewName } WHERE CURRENT OF CursorName
DESCRIBE
DESCRIBE [OUTPUT
INPUT
RESULT] StatementName {INTO [[SQL] DESCRIPTOR]
USING [SQL] DESCRIPTOR}{SQLDA
AreaName }
DISABLE AUDIT LOGGING
DISABLE AUDIT LOGGING
DISABLE RULES
DISABLE RULES