ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 601
SQL Syntax Summary
CHECKPOINT
CHECKPOINT [: HostVariable
: LocalVariable
: ProcedureParameter ]
CLOSE
CLOSE CursorName [USING {[SQL] DESCRIPTOR {SQLDA
Areaname }
: HostVariable [[INDICATOR]: Indicator ][,...] } ]
COMMIT ARCHIVE
COMMIT ARCHIVE
COMMIT WORK
COMMIT WORK [RELEASE]
CONNECT
CONNECT TO { ‘DBEnvironmentName’
: HostVariable1 }[AS { ‘ConnectionName’
:HostVariable2 }]
[USER { ‘UserID’
:HostVariable3 }[USING : HostVariable4 ]]
CREATE DBEFILE
CREATE DBEFILE DBEFileName WITH PAGES = DBEFileSize , NAME = ‘SystemFileName’
[, INCREMENT = DBEFileIncrSize [, MAXPAGES = DBEFileMaxSize ]]
[, TYPE = {TABLE
INDEX
MIXED }]
CREATE DBEFILESET
CREATE DBEFILESET DBEFileSetName
CREATE GROUP
CREATE GROUP [ Owner. ] GroupName
CREATE INDEX
CREATE [UNIQUE][CLUSTERING]INDEX [ Owner. ] Indexname ON
[ Owner. ] TableName ( {ColumnName [ASC
DESC]}[,...])