ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 599
SQL Syntax Summary
A SQL Syntax Summary
This listing of SQL syntax differs from the previous version in the following ways:
• The braces { } and brackets [ ] are shown in standard type size.
• Commands and keywords are shown in BOLD UPPERCASE characters
ADD DBEFILE
ADD DBEFILE DBEFileName TO DBEFILESET DBEFileSetName
ADD TO GROUP
ADD { DBEUserID
GroupName
ClassName }[,...]TO GROUP TargetGroupName
ADVANCE
ADVANCE CursorName [USING [SQL] DESCRIPTOR {SQLDA
AreaName }]
ALTER DBEFILE
ALTER DBEFILE DBEFileName SET TYPE = {TABLE
INDEX
MIXED }
ALTER TABLE
ALTER TABLE [ Owner. ] TableName { AddColumnSpecification
AddConstraintSpecification
DropConstraintSpecification
SetTypeSpecification
SetPartitionSpecification }
AddColumnSpecification
ADD{ ( ColumnDefinition [,...])
ColumnDefinition } [CLUSTERING ON CONSTRAINT [ ConstraintID ]]