ADD DBEFILE DBEFileNameTO DBEFILESET DBEFileSetName

ADD { DBEUserID GroupName ClassName } [ , ... ]TO GROUPTargetGroupName

ADVANCE CursorName [ USING [SQL] DESCRIPTOR { SQLDA AreaName }]

ALTER DBEFILE DBEFileName SET TYPE = { TABLE INDEX MIXED }

ALTER TABLE [Owner.] TableName { AddColumnSpecification AddConstraintSpecification DropConstraintSpecification SetTypeSpecification SetPartitionSpecification }

{ :LocalVariable :ProcedureParameter } = Expression;

BEGIN [statement;] [ ... ] END;

BEGIN ARCHIVE

BEGIN DECLARE SECTION

BEGIN WORK [Priority] [ RR CS RC RU ] [ LABEL { 'LabelString' :HostVariable }] [[ PARALLEL NO ] FILL ]

CHECKPOINT [ :HostVariable :LocalVariable :ProcedureParameter ]

CLOSE CursorName [ USING {[SQL] DESCRIPTOR { SQLDA AreaName } :HostVariable [[INDICATOR] :Indicator ] [,...] }]

COMMIT ARCHIVE

COMMIT WORK [RELEASE]

CONNECT TO { 'DBEnvironmentName' :HostVariable1 } [ AS { 'ConnectionName' :HostVariable2 }] [ USER { 'UserID' :HostVariable3 } [USINGHostVariable4]]

CREATE DBEFILE DBEFilenameWITH PAGES = DBEFileSize,NAME 'SystemFileName' [ , INCREMENT = DBEFileIncrSize [, MAXPAGES = DBEFileMaxSize]] [ ,TYPE = { TABLE INDEX MIXED }]

CREATE DBEFILESET DBEFileSetName

CREATE GROUP [Owner.] GroupName

CREATE [UNIQUE] [CLUSTERING] INDEX [Owner.] IndexNameON [Owner.] TableName ( { ColumnName [ ASC DESC ]} [,...])

CREATE PARTITION PartitionName WITH ID = PartitionNumber

CREATE PROCEDURE [Owner.] ProcedureName [LANG = ProcLangName] [ ( ParameterDeclaration [, ParameterDeclaration] [ ... ]) ] [ WITH RESULT ResultDeclaration [, ResultDeclaration] [ ... ] ] AS BEGIN [ProcedureStatement] [ ... ]END [IN DBEFileSetName]

CREATE RULE [Owner.] RuleName AFTER StatementType[ ,... ] { ON OF FROM INTO } [Owner] .TableName [ REFERENCING {OLD AS OldCorrelationName} NEW AS NewCorrelationName [ ... ] ] [WHERE FiringCondition] EXECUTE PROCEDURE [OwnerName.] ProcedureName [ (ParameterValue [ , ... ]) ] [IN DBEFileSetName]

CREATE SCHEMA AUTHORIZATION AuthorizationName [ TableDefinition ViewDefinition IndexDefinition ProcedureDefinition RuleDefinition CreateGroup AddToGroup GrantStatement ] [ ... ]

CREATE [ PRIVATE PUBLICREAD PUBLIC PUBLICROW ] TABLE [Owner.] TableName [LANG = TableLanguageName] ( { ColumnDefinition UniqueConstraint ReferentialConstraint CheckConstraint } [ ,... ]) [ UNIQUE HASH ON (HashColumnName[ ,... ]) PAGES =PrimaryPages HASH ON CONSTRAINT [ConstraintID] PAGES =PrimaryPages CLUSTERING ON CONSTRAINT [ConstraintID]] [ IN PARTITION { PartitionName DEFAULT NONE }] [IN DBEFileSetName1]

CREATE TEMPSPACE TempSpaceName WITH [MAXFILEPAGES =MaxTempFileSize,] LOCATION ='PhysicalLocation'

CREATE VIEW [Owner.] ViewName [ ( ColumnName [ ,... ]) ] AS QueryExpression [ IN DBEFileSetName ] [ WITH CHECK OPTION [ CONSTRAINT ConstraintID ]]

DECLARE CursorName [ IN DBEFileSetName ] CURSOR FOR {{ QueryExpression SelectStatementName } [ FOR UPDATE OF {ColumnName} [ ,... ] FOR READ ONLY ] ExecuteProcedureStatement ExecuteStatementName }

DECLARE {LocalVariable} [ ,... ] VariableType [ LANG = VariableLangName ] [ DEFAULT { Constant NULL CurrentFunction }] [NOT NULL]

DELETE FROM {[Owner.] TableName [Owner.] ViewName } [ WHERE SearchCondition ]

DELETE FROM {[Owner.] TableName [Owner.] ViewName } WHERE CURRENT OF CursorName

DESCRIBE [ OUTPUT INPUT RESULT ] StatementName { INTO [[SQL] DESCRIPTOR ] USING [SQL] DESCRIPTOR } { SQLDA AreaName }

DISABLE AUDIT LOGGING

DISABLE RULES

DISCONNECT { 'ConnectionName' 'DBEnvironmentName' :HostVariable ALL CURRENT }

DROP DBEFILE DBEFileName

DROP DBEFILESET DBEFileSetName

DROP GROUP GroupName

DROP INDEX [Owner.] IndexName [ FROM [Owner.] TableName ]

DROP MODULE [Owner.] ModuleName [PRESERVE]

DROP PARTITION PartitionName

DROP PROCEDURE [Owner.] ProcedureName [PRESERVE]

DROP RULE [Owner.] RuleName [ FROM TABLE [Owner.] TableName ]

DROP TABLE [Owner.] TableName

DROP TEMPSPACE TempSpaceName

DROP VIEW [Owner.] ViewName

ENABLE AUDIT LOGGING

ENABLE RULES

END DECLARE SECTION

EXECUTE { StatementName [Owner.] ModuleName [(SectionNumber)]} [ USING {[SQL] DESCRIPTOR {[INPUT] { SQLDA AreaName1 } [ AND OUTPUT { SQLDA AreaName2 }] OUTPUT { SQLDA AreaName }} [INPUT] HostVariableSpecification1 [ AND OUTPUT HostVariableSpecification2 ] OUTPUT HostVariableSpecification :Buffer [ ,:StartIndex [, :NumberOfRows]]}]

EXECUTE IMMEDIATE { 'String' :HostVariable }

EXECUTE PROCEDURE [:ReturnStatusVariable = ] [Owner.] ProcedureName [ ( [ActualParameter] [ , [ActualParameter]] [ ... ]) ]

[BULK] FETCH CursorName { INTO HostVariableSpecification USING {[SQL] DESCRIPTOR { SQLDA AreaName } HostVariableSpecification }}

GENPLAN [ WITH (VariableName DataType [ ,.. ]) ] FOR SQLStatement

{ GOTO GO TO } { Label Integer }

GRANT { ALL [PRIVILEGES] { SELECT INSERT DELETE ALTER INDEX UPDATE [ ( {ColumnName} [ , ... ] ) ] REFERENCES [ ( {ColumnName} [ , ... ] ) ]} | , ... | } ON {[Owner.] TableName [Owner.] ViewName } TO { DBEUserID GroupName ClassName PUBLIC } [ , ... ] [WITH GRANT OPTION] [ BY { DBEUserID ClassName }]

IF Condition THEN [ Statement; [ ... ] ] [ ELSEIF Condition THEN [ Statement; [ ... ] ]] [ ELSE [ Statement; [ ... ] ]] ENDIF;

INCLUDE { SQLCA [[IS] EXTERNAL ] SQLDA }

[BULK] INSERT INTO {[Owner.] TableName [Owner.] ViewName } [ ( { ColumnName [ , ... ] ) }] VALUES ( { SingleRowValues BulkValues ? } )

INSERT INTO {[Owner.] TableName [Owner.] ViewName } [ (ColumnName [ , ... ]) ] QueryExpression

Label: Statement

LOCK TABLE [Owner.] TableName IN { SHARE [UPDATE] EXCLUSIVE } MODE

LOG COMMENT { 'String' :HostVariable :ProcedureParameter :ProcedureLocalVariable ? }

OPEN CursorName [ KEEP CURSOR [ WITH LOCKS WITH NOLOCKS ]] [ USING {[SQL] DESCRIPTOR { SQLDA AreaName } HostVariableName [[INDICATOR] :IndicatorVariable ] [ , ... ] }]

PREPARE [REPEAT] { StatementName [Owner.] ModuleName [(SectionNumber)]} [ IN DBEFileSetName ] FROM { 'String' :HostVariable }

PRINT { 'Constant' :LocalVariable :Parameter ::Built-inVariable } ;

RAISE ERROR [ErrorNumber] [ MESSAGE ErrorText ]

REFETCH CursorName INTO { :HostVariable [[INDICATOR] :Indicator ]} [ , ... ]

RELEASE

REMOVE DBEFILE DBEFileName FROM DBEFILESET DBEFileSetName

REMOVE { DBEUserID GroupName ClassName } [ , ... ] FROM GROUP [Owner.] TargetGroupName

RESET { SYSTEM.ACCOUNT [ FOR USER { * DBEUserID }] SYSTEM.COUNTER }

RETURN [ReturnStatus] ;

ROLLBACK WORK [ TO { SavePointNumber :HostVariable :LocalVariable :ProcedureParameter } RELEASE ]

SAVEPOINT [ :HostVariable :LocalVariable :ProcedureParameter ]

SET CONNECTION { 'ConnectionName' :HostVariable }

SET ConstraintType [ , ... ] CONSTRAINTS { DEFERRED IMMEDIATE }

SET DEFAULT { SECTIONSPACE TABLESPACE } TO DBEFILESET DBEFileSetName FOR PUBLIC

SET DML ATOMICITY AT { ROW STATEMENT } LEVEL

SET MULTITRANSACTION { ON OFF }

SETOPT { CLEAR GENERAL { ScanAccess JoinAlgorithm } [ , ... ] BEGIN { GENERAL { ScanAccess JoinAlgorithm }} [ ; ... ] END }

SET PRINTRULES [ ON OFF ]

SET SESSION { ISOLATION LEVEL { RR CS RC RU REPEATABLE READ SERIALIZABLE CURSOR STABILITY READ COMMITTED READ UNCOMMITTED :HostVariable1 } PRIORITY { Priority :HostVariable2 } LABEL { 'LabelString' :HostVariable3 } ConstraintType [ , ... ] CONSTRAINTS { DEFERRED IMMEDIATE } DML ATOMICITY AT { STATEMENT ROW } LEVEL [{ PARALLEL NO }] FILL } [ , ... ]

SET TRANSACTION { ISOLATION LEVEL { RR CS RC RU REPEATABLE READ SERIALIZABLE CURSOR STABILITY READ COMMITTED READ UNCOMMITTED :HostVariable1 } PRIORITY { Priority :HostVariable2 } LABEL { 'LabelString' :HostVariable3 } ConstraintType [ , ... ] CONSTRAINTS { DEFERRED IMMEDIATE } DML ATOMICITY AT { STATEMENT ROW } LEVEL } [ , ... ]

SET USER TIMEOUT [TO] {{ TimeoutValue :HostVariable } [ SECONDS MINUTES ] DEFAULT MAXIMUM }

SQLEXPLAIN :HostVariable

START DBE 'DBEnvironmentName' [AS ConnectionName'] [MULTI] [ BUFFER = (DataBufferPages, LogBufferPages) TRANSACTION = MaxTransactions MAXIMUM TIMEOUT = { TimeoutValue [ SECONDS MINUTES ] NONE } DEFAULT TIMEOUT = { TimeoutValue [ SECONDS MINUTES ] MAXIMUM } RUN BLOCK = ControlBlockPages ] |,...|

START DBE 'DBEnvironmentName' [AS 'ConnectionName'] [MULTI] NEW [{ DUAL AUDIT } |...| LOG BUFFER = (DataBufferPages, LogBufferPages) LANG = LanguageName TRANSACTION = MaxTransactions MAXIMUM TIMEOUT = { TimeoutValue [ SECONDS MINUTES ] NONE } DEFAULT TIMEOUT = { TimeoutValue [ SECONDS MINUTES ] MAXIMUM } RUN BLOCK = ControlBlockPages DEFAULT PARTITION = { DefaultPartitionNumber NONE } COMMENT PARTITION = { CommentPartitionNumber DEFAULT NONE } MAXPARTITIONS = MaximumNumberOfPartitions AUDIT NAME = 'AuditName' { COMMENT DATA DEFINITION STORAGE AUTHORIZATION SECTION ALL } |...| AUDIT ELEMENTS DBEFile0Definition DBELogDefinition ] |,...|

START DBE 'DBEnvironmentName' [AS 'ConnectionName'] [MULTI] NEWLOG [{ ARCHIVE DUAL AUDIT } |...| LOG BUFFER = (DataBufferPages, LogBufferPages) TRANSACTION = MaxTransactions MAXIMUM TIMEOUT = { TimeoutValue [ SECONDS MINUTES ] NONE } DEFAULT TIMEOUT = { TimeoutValue [ SECONDS MINUTES ] MAXIMUM } RUN BLOCK = ControlBlockPages DEFAULT PARTITION = { DefaultPartitionNumber NONE } COMMENT PARTITION = { CommentPartitionNumber DEFAULT NONE } MAXPARTITIONS = MaximumNumberOfPartitions ARG CHOICE="PLAIN">AUDIT NAME = 'AuditName' { COMMENT DATA DEFINITION STORAGE AUTHORIZATION SECTION ALL } |...| AUDIT ELEMENTS ] |,...| NewLogDefinition

STOP DBE

TERMINATE USER { DBEUserID SessionID }

TRANSFER OWNERSHIP OF {[TABLE] [Owner.] TableName [VIEW] [Owner.] ViewName PROCEDURE [Owner.] ProcedureName GROUP GroupName } TO NewOwnerName

TRUNCATE TABLE [Owner.] TableName

UPDATE {[Owner.] TableName [Owner.] ViewName } SET { ColumnName = { Expression 'LongColumnIOString' NULL }} [ , ... ] [ WHERE SearchCondition]

UPDATE STATISTICS FOR TABLE {[Owner.] TableName SYSTEM.SystemViewName }

UPDATE {[Owner.] TableName [Owner.] ViewName } SET { ColumnName = { Expression 'LongColumnIOString' NULL }} [ , ... ] WHERE CURRENT OF CursorName

VALIDATE [DROP SETOPTINFO] { MODULE { [Owner.] ModuleName } [ , ... ] PROCEDURE { [Owner.] ProcedureName } [ , ... ] ALL { MODULES PROCEDURES }}

WHENEVER { SQLERROR SQLWARNING NOT FOUND } { STOP CONTINUE GOTO Label GO TO Label }

WHILE Condition DO [Statement; [ ... ] ] ENDWHILE;