ADD DBEFILE DBEFileName TO DBEFILESET DBEFileSetName

ADD { DBEUserID GroupName ClassName } [,...] TO GROUP TargetGroupName

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 ]} [USING :HostVariable4]]

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

CREATE DBEFILESET DBEFileSetName

CREATE GROUP [Owner.] GroupName

CREATE [UNIQUE] [CLUSTERING] INDEX [Owner.]IndexName ON [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 [WITH AUTOCOMMIT] 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 (HostVariableDefinition) ] FOR { SQLStatement MODULE SECTION [Owner.] ModuleName(SectionName) PROCEDURE SECTION [Owner.] ProcedureName(SectionName) }

{ 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

RENAME COLUMN [Owner.] TableName.ColumnName TO NewColumnName

RENAME TABLE [Owner.] TableName TO NewTableName

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 ON { TIMEOUT DEADLOCK } ROLLBACK { QUERY TRANSACTION } USER TIMEOUT [TO] { DEFAULT MAXIMUM TimeoutValue [ { SECONDS MINUTES }] :HostVariable4 [{ SECONDS MINUTES }] } TERMINATION AT { SESSION TRANSACTION QUERY RESTRICTED } 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 ON { TIMEOUT DEADLOCK } ROLLBACK { QUERY TRANSACTION } USER TIMEOUT [TO] { DEFAULT MAXIMUM TimeoutValue [ { SECONDS MINUTES }] :HostVariable4 [{ SECONDS MINUTES }] } TERMINATION AT { SESSION TRANSACTION QUERY RESTRICTED } 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 AUDIT NAME = 'AuditName' { COMMENT DATA DEFINITION STORAGE AUTHORIZATION SECTION ALL } |...| AUDIT ELEMENTS ] |,...| NewLogDefinition

STOP DBE

TERMINATE QUERY FOR { CID ConnectionID XID TransactionID }

TERMINATE TRANSACTION FOR { CID ConnectionID XID TransactionID }

TERMINATE USER { DBEUserID SessionID CID ConnectionID }

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 [ FORCE DROP SETOPTINFO ] { MODULE { {[Owner.]ModuleName }[ ... ] {SECTION [Owner.]ModuleName (Section Number)}[ ,... ] } PROCEDURE { { [Owner.]ProcedureName }[ ,... ] {SECTION [Owner.]ProcedureName (Section Number)}[ ,... ] } ALL { MODULES PROCEDURES } [WITH AUTOCOMMIT] }

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

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