ALLBASE/SQL Reference Manual (36216-90216)

602 AppendixA
SQL Syntax Summary
CREATE PARTITION
CREATE PARTITION PartitionName WITH ID = PartitionNumber
CREATE PROCEDURE
CREATE PROCEDURE [ Owner. ] ProcedureName [LANG = ProcLangName ]
[(ParameterDeclaration [, ParameterDeclaration ][...])]
[WITH RESULT ResultDeclaration [, ResultDeclaration ][...]]
AS BEGIN [ ProcedureStatement ][...] END [IN DBEFileSetName ]
ParameterDeclaration
ParameterName ParameterType [LANG = ParameterLanguage ]
[DEFAULT DefaultValue ][NOT NULL][OUTPUT[ONLY]]
ResultDeclaration
ResultType [LANG = ResultLanguage ][NOT NULL]
CREATE RULE
CREATE RULE [ Owner. ] RuleName
AFTER StatementType [,...][ON
OF
FROM
INTO} [ Owner. ] TableName
[REFERENCING{OLD AS OldCorrellationName
NEW AS NewCorrelationName }[...]] [WHERE FiringCondition ]
EXECUTE PROCEDURE [ OwnerName .] ProcedureName [( ParameterValue [,...])]
[IN DBEFileSetName ]
CREATE SCHEMA
CREATE SCHEMA AUTHORIZATION AuthorizationName [ TableDefinition
ViewDefinition
IndexDefinition
ProcedureDefinition
RuleDefinition
CreateGroup
AddToGroup
GrantStatement ][...]