HP 3000 Manuals HP 3000 Manuals
Appendix A SQL Syntax Summary
SQL Syntax Summary
ADD DBEFILE
ADD DBEFILE DBEFileName TO DBEFILESET DBEFileSetName
ADD TO GROUP
{DBEUserID}
ADD {GroupName} [,...] TO GROUP TargetGroupName
{ClassName}
[REV BEG]
ADVANCE
ADVANCE CursorName [USING [SQL] DESCRIPTOR {SQLDA }]
[ {AreaName}]
[REV END]
ALTER DBEFILE
{TABLE}
ALTER DBEFILE DBEFileName SET TYPE = {INDEX}
{MIXED}
[REV BEG]
ALTER TABLE
{AddColumnSpecification }
{AddConstraintSpecification }
ALTER TABLE [Owner.]TableName {DropConstraintSpecification}
{SetTypeSpecification }
{SetPartitionSpecification }
[REV END][REV BEG]
AddColumnSpecification.
ADD{(ColumnDefinition [,...] )} [CLUSTERING ON CONSTRAINT [ConstraintID]]
{Column Definition }
[REV END][REV BEG]
AddConstraintSpecification.
{ {UniqueConstraint [CONSTRAINT ConstraintID1] } }
ADD CONSTRAINT{({ReferentialConstraint [CONSTRAINT ConstraintID1]} [,...] )}
{ {CheckConstraint [CONSTRAINT ConstraintID1] } }
[CLUSTERING ON CONSTRAINT [ConstraintID2]]
DropConstraintSpecification.
DROP CONSTRAINT{(ConstraintID [,...] )}
{ConstraintID }
SetTypeSpecification.
{PRIVATE }
SET TYPE {PUBLICREAD} [RESET AUTHORITY ]
{PUBLIC } [PRESERVE AUTHORITY]
{PUBLICROW }
SetPartitionSpecification.
{PartitionName}
SET PARTITION {DEFAULT }
{NONE }
[REV END]
Assignment (=)
{:LocalVariable } = Expression;
{:ProcedureParameter}
BEGIN
BEGIN [statement;] [...] END;
BEGIN ARCHIVE
BEGIN ARCHIVE
BEGIN DECLARE SECTION
BEGIN DECLARE SECTION
[REV BEG]
BEGIN WORK
[RR]
BEGIN WORK [Priority] [CS] [LABEL {'LabelString'}] [[PARALLEL] FILL]
[RC] [ {:HostVariable}] [[NO ] ]
[RU]
[REV END]
CHECKPOINT
[REV BEG]
[:HostVariable ]
CHECKPOINT [:LocalVariable ]
[:ProcedureParameter]
[REV END]
CLOSE
[REV BEG]
[ {[SQL]DESCRIPTOR {SQLDA } }]
CLOSE CursorName [USING { {AreaName} }]
[ { }]
[ {:HostVariable [[INDICATOR] :Indicator] [,...]}]
[REV END]
COMMIT ARCHIVE
COMMIT ARCHIVE
COMMIT WORK
COMMIT WORK [RELEASE]
CONNECT
CONNECT TO {'DBEnvironmentName'} [AS {'ConnectionName'}]
{:HostVariable1 } [ {:HostVariable2 }]
[USER {'UserID' } [USING :HostVariable4]]
[ {:HostVariable3} ]
CREATE DBEFILE
[REV BEG]
CREATE DBEFILE DBEFilename WITH PAGES = DBEFileSize, NAME = 'SystemFileName'
[, INCREMENT = DBEFileIncrSize[, MAXPAGES = DBEFileMaxSize]]
[ {TABLE}]
[,TYPE = {INDEX}] [,DEVICE = volume;]
[ {MIXED}]
[REV END]
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]}
[REV BEG]
CREATE PARTITION
CREATE PARTITION PartitionName WITH ID = PartitionNumber
[REV END][REV BEG]
CREATE PROCEDURE
CREATE PROCEDURE [Owner.]ProcedureName [LANG = ProcLangName]
[( ParameterDeclaration [, ParameterDeclaration] [...] )]
[WITH RESULT ResultDeclaration [, ResultDeclaration] [...]] AS BEGIN
[ProcedureStatement] [...] END [IN DBEFileSetName]
ParameterDeclaration.
ParameterName ParameterType [LANG = ParameterLanguage]
[DEFAULT DefaultValue] [NOT NULL] [OUTPUT [ONLY]]
ResultDeclaration.
ResultType [LANG = ResultLanguage] [NOT NULL]
[REV END]
CREATE RULE
{ON }
CREATE RULE [Owner.]RuleName AFTER StatementType [,...] {OF }
{FROM}
{INTO}
[Owner].TableName [REFERENCING {OLD AS OldCorrelationName}[...]]
[ {NEW AS NewCorrelationName} ]
[WHERE FiringCondition] EXECUTE PROCEDURE [OwnerName.]ProcedureName
[(ParameterValue [,...])] [REV BEG][IN DBEFileSetName] [REV END]
CREATE SCHEMA
[TableDefinition ]
[ViewDefinition ]
[IndexDefinition ]
CREATE SCHEMA AUTHORIZATION AuthorizationName [ProcedureDefinition] [...]
[RuleDefinition ]
[CreateGroup ]
[AddToGroup ]
[GrantStatement ]
[REV BEG]
CREATE TABLE
[PRIVATE ]
CREATE [PUBLICREAD] TABLE [Owner.]TableName
[PUBLIC ]
[PUBLICROW ]
{ColumnDefinition }
[LANG = TableLanguageName] ( {UniqueConstraint } [,...])
{ReferentialConstraint}
{CheckConstraint }
[UNIQUE HASH ON (HashColumnName [,...]) PAGES = PrimaryPages]
[HASH ON CONSTRAINT [ConstraintID] PAGES = PrimaryPages ]
[CLUSTERING ON CONSTRAINT [ConstraintID] ]
[ {PartitionName}]
[IN PARTITION {DEFAULT }] [IN DBEFileSetName1]
[ {NONE }]
[REV END][REV BEG]
Column Definition.
ColumnName {ColumnDataType } [LANG = ColumnLanguageName]
{LongColumnType [IN DBEFileSetName2]}
[ {Constant }]
[[NOT] CASE SENSITIVE] [DEFAULT {USER }]
[ {NULL }]
[ {CurrentFunction}]
[NOT NULL [{UNIQUE } [CONSTRAINT ConstraintID]] ]
[ [{PRIMARY KEY} ] ]
[ ]
[REFERENCES RefTableName [(RefColumnName)] [CONSTRAINT ConstraintID]]
[[...] ]
[ ]
[CHECK (SearchCondition) [CONSTRAINT ConstraintID] ]
[[IN DBEFileSetName3] ]
[...]
[REV END][REV BEG]
Unique Constraint (Table Level).
{UNIQUE } ( ColumnName [,...]) [CONSTRAINT ConstraintID]
{PRIMARY KEY}
[REV END][REV BEG]
Referential Constraint (Table Level).
FOREIGN KEY ( FKColumnName [,...]) REFERENCES RefTableName
[( RefColumnName [,...])] [CONSTRAINT ConstraintID]
[REV END][REV BEG]
Check Constraint (Table Level).
CHECK (SearchCondition) [CONSTRAINT ConstraintID] [IN DBEFileSetName3]
[REV END]
CREATE TEMPSPACE
CREATE TEMPSPACE TempSpaceName WITH [MAXFILEPAGES = MaxTempFileSize,]
LOCATION ='PhysicalLocation'
CREATE VIEW
[REV BEG]CREATE VIEW [Owner.]ViewName [( ColumnName [,...])]
AS QueryExpression [IN DBEFileSetName]
[WITH CHECK OPTION [CONSTRAINT ConstraintID]] [REV END]
[REV BEG]
DECLARE CURSOR
DECLARE CursorName [IN DBEFileSetName] CURSOR FOR
{{QueryExpression } [FOR UPDATE OF {ColumnName} [,...]]}
{{SelectStatementName} [FOR READ ONLY ]}
{ }
{ExecuteProcedureStatement }
{ExecuteStatementName }
[REV END]
DECLARE Variable
DECLARE {LocalVariable} [,...] VariableType [LANG = VariableLangName]
[ {Constant }]
[DEFAULT {NULL }] [NOT NULL]
[ {CurrentFunction}]
DELETE
DELETE FROM {[Owner.]TableName} [WHERE SearchCondition]
{[Owner.]ViewName }
DELETE WHERE CURRENT
DELETE FROM {[Owner.]TableName} WHERE CURRENT OF CursorName
{[Owner.]ViewName }
[REV BEG]
DESCRIBE
[OUTPUT]
DESCRIBE [INPUT ] StatementName {INTO [[SQL] DESCRIPTOR]} {SQLDA }
[RESULT] {USING [SQL] DESCRIPTOR } {AreaName}
[REV END][REV BEG]
DISABLE AUDIT LOGGING
DISABLE AUDIT LOGGING
[REV END]
DISABLE RULES
DISABLE RULES
DISCONNECT
{'ConnectionName' }
{'DBEnvironmentName'}
DISCONNECT {:HostVariable }
{ALL }
{CURRENT }
DROP DBEFILE
DROP DBEFILE DBEFileName
DROP DBEFILESET
DROP DBEFILESET DBEFileSetName
DROP GROUP
DROP GROUP GroupName
DROP INDEX
DROP INDEX [Owner.]IndexName [FROM [Owner.]TableName]
DROP MODULE
DROP MODULE [Owner.]ModuleName [PRESERVE]
[REV BEG]
DROP PARTITION
DROP PARTITION PartitionName
[REV END]
DROP PROCEDURE
DROP PROCEDURE [Owner.]ProcedureName [PRESERVE]
DROP RULE
DROP RULE [Owner.]RuleName [FROM TABLE [Owner.]TableName]
DROP TABLE
DROP TABLE [Owner.]TableName
DROP TEMPSPACE
DROP TEMPSPACE TempSpaceName
DROP VIEW
DROP VIEW [Owner.]ViewName
[REV BEG]
ENABLE AUDIT LOGGING
ENABLE AUDIT LOGGING
[REV END]
ENABLE RULES
ENABLE RULES
END DECLARE SECTION
END DECLARE SECTION
[REV BEG]
EXECUTE
EXECUTE {StatementName }
{[Owner.]ModuleName [(SectionNumber)]}
[ { {[INPUT] {SQLDA } [AND OUTPUT {SQLDA }]} }]
[ { { {AreaName1} [ {AreaName2}]} }]
[ {[SQL] DESCRIPTOR{ } }]
[ { {OUTPUT {SQLDA } } }]
[USING { { {AreaName} } }]
[ { }]
[ {[INPUT] HostVariableSpecification1 [AND OUTPUT HostVariableSpecification2]}]
[ {OUTPUT HostVariableSpecification }]
[ {:Buffer [,:StartIndex [, :NumberOfRows]] }]
HostVariableSpecification.
:HostVariableName[[INDICATOR] :IndicatorVariable] [,...]
[REV END][REV BEG]
EXECUTE IMMEDIATE
EXECUTE IMMEDIATE {'String' }
{:HostVariable}
[REV END][REV BEG]
EXECUTE PROCEDURE
EXECUTE PROCEDURE [:ReturnStatusVariable =] [Owner.]ProcedureName
[( [ActualParameter] [, [ActualParameter]][...] )]
ActualParameter.
[ParameterName =] ParameterValue [OUTPUT [ONLY]]
[REV END][REV BEG]
FETCH
{INTO HostVariableSpecification }
{ {[SQL]DESCRIPTOR {SQLDA }}}
[BULK] FETCH CursorName {USING { {AreaName}}}
{ { }}
{ {HostVariableSpecification }}
BULK HostVariableSpecification.
:Buffer [,:StartIndex [,:NumberOfRows]]
Non-BULK HostVariableSpecification.
{:HostVariable [[INDICATOR] :Indicator]} [,...]
[REV END]
GENPLAN
GENPLAN [WITH (VariableName DataType [,..])] FOR SQLStatement
GOTO
{GOTO } {Label }
{GO TO} {Integer}
[REV BEG]
GRANT
{ALL [PRIVILEGES] }
{{SELECT } }
{{INSERT } }
GRANT {{DELETE } } ON
{{ALTER } |,...|}
{{INDEX } }
{{UPDATE [({ColumnName} [,...])] } }
{{REFERENCES [({ColumnName} [,...])]} }
{DBEUserID}
{[Owner.]TableName} TO {GroupName} [,...] [WITH GRANT OPTION]
{[Owner.]ViewName } {ClassName}
{PUBLIC }
[BY {DBEUserID}]
[ {ClassName}]
[REV END][REV BEG]
Grant RUN or EXECUTE Authority.
{{DBEUserID} }
GRANT {RUN ON [Owner.]ModuleName } TO {{GroupName} [,...]}
{EXECUTE ON PROCEDURE [Owner.]ProcedureName} {{ClassName} }
{PUBLIC }
[REV END][REV BEG]
Grant CONNECT, DBA, or RESOURCE Authority.
{CONNECT } {DBEUserID}
GRANT{DBA }TO {GroupName}[,...]
{RESOURCE} {ClassName}
[REV END][REV BEG]
Grant DBEFileSet Authority.
{DBEUserID}
GRANT {SECTIONSPACE} [,...] ON DBEFILESET DBEFileSetName TO {GroupName}
{TABLESPACE } {ClassName}
{PUBLIC }
[,...]
[REV END]
IF
IF Condition THEN [Statement;[...]]
[ELSEIF Condition THEN [Statement; [...]]] [ELSE [Statement; [...]]]
ENDIF;
INCLUDE
INCLUDE {SQLCA [[IS] EXTERNAL]}
{SQLDA }