ALLBASE/SQL Reference Manual (36216-90216)

600 AppendixA
SQL Syntax Summary
AddConstraintSpecification
ADD CONSTRAINT ({ UniqueConstraint
ReferentialConstraint
CheckConstraint }[,...])
[CLUSTERING ON CONSTRAINT [ ConstraintID1 ]]
DropConstraintSpecification
DROP CONSTRAINT {( ConstraintID [,...])
ConstraintID }
SetTypeSpecification
SET TYPE {PRIVATE
PUBLICREAD
PUBLIC
PUBLICROW } [RESET AUTHORITY
PRESERVE AUTHORITY]
SetPartitionSpecification
SET PARTITION { PartitionName
DEFAULT
NONE }
Assignment (=)
{: LocalVariable
: ProcedureParameter }= Expression ;
BEGIN
BEGIN [ Statement ;] [...] END;
BEGIN ARCHIVE
BEGIN ARCHIVE
BEGIN DECLARE SECTION
BEGIN DECLARE SECTION
BEGIN WORK
BEGIN WORK [ Priority ] [RR
CS
RC
RU][LABEL { ‘LabelString’
: HostVariable }] [[PARALLEL
NO ] FILL]