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}
ADVANCE
ADVANCE CursorName [USING [SQL] DESCRIPTOR {SQLDA }]
[ {AreaName}]
ALTER DBEFILE
{TABLE}
ALTER DBEFILE DBEFileName SET TYPE = {INDEX}
{MIXED}
ALTER TABLE
{AddColumnSpecification }
{AddConstraintSpecification }
ALTER TABLE [Owner.]TableName {DropConstraintSpecification}
{SetTypeSpecification }
{SetPartitionSpecification }
AddColumnSpecification.
ADD{(ColumnDefinition [,...] )} [CLUSTERING ON CONSTRAINT [ConstraintID]]
{Column Definition }
[REV BEG]
AddConstraintSpecification.
{UniqueConstraint }
ADD CONSTRAINT ({ReferentialConstraint} [,...] )
{CheckConstraint }
[CLUSTERING ON CONSTRAINT [ConstraintID1]]
[REV END]
DropConstraintSpecification.
DROP CONSTRAINT{(ConstraintID [,...] )}
{ConstraintID }
SetTypeSpecification.
{PRIVATE }
SET TYPE {PUBLICREAD} [RESET AUTHORITY ]
{PUBLIC } [PRESERVE AUTHORITY]
{PUBLICROW }
SetPartitionSpecification.
{PartitionName}
SET PARTITION {DEFAULT }
{NONE }
Assignment (=)
{:LocalVariable } = Expression;
{:ProcedureParameter}
BEGIN
BEGIN [statement;] [...] END;
BEGIN ARCHIVE
BEGIN ARCHIVE
BEGIN DECLARE SECTION
BEGIN DECLARE SECTION
BEGIN WORK
[RR]
BEGIN WORK [Priority] [CS] [LABEL {'LabelString'}] [[PARALLEL] FILL]
[RC] [ {:HostVariable}] [[NO ] ]
[RU]
CHECKPOINT
[:HostVariable ]
CHECKPOINT [:LocalVariable ]
[:ProcedureParameter]
CLOSE
[ {[SQL]DESCRIPTOR {SQLDA } }]
CLOSE CursorName [USING { {AreaName} }]
[ { }]
[ {:HostVariable [[INDICATOR] :Indicator] [,...]}]
COMMIT ARCHIVE
COMMIT ARCHIVE
COMMIT WORK
COMMIT WORK [RELEASE]
CONNECT
CONNECT TO {'DBEnvironmentName'} [AS {'ConnectionName'}]
{:HostVariable1 } [ {:HostVariable2 }]
[USER {'UserID' } [USING :HostVariable4]]
[ {:HostVariable3} ]
CREATE DBEFILE
CREATE DBEFILE DBEFilename WITH PAGES = DBEFileSize, NAME = 'SystemFileName'
[, INCREMENT = DBEFileIncrSize[, MAXPAGES = DBEFileMaxSize]]
[ {TABLE}]
[,TYPE = {INDEX}] [,DEVICE = volume;]
[ {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]}
CREATE PARTITION
CREATE PARTITION PartitionName WITH ID = PartitionNumber
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]
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 [,...])] [IN DBEFileSetName]
CREATE SCHEMA
[TableDefinition ]
[ViewDefinition ]
[IndexDefinition ]
CREATE SCHEMA AUTHORIZATION AuthorizationName [ProcedureDefinition] [...]
[RuleDefinition ]
[CreateGroup ]
[AddToGroup ]
[GrantStatement ]
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 }]
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] ]
[...]
Unique Constraint (Table Level).
{UNIQUE } ( ColumnName [,...]) [CONSTRAINT ConstraintID]
{PRIMARY KEY}
Referential Constraint (Table Level).
FOREIGN KEY ( FKColumnName [,...]) REFERENCES RefTableName
[( RefColumnName [,...])] [CONSTRAINT ConstraintID]
Check Constraint (Table Level).
CHECK (SearchCondition) [CONSTRAINT ConstraintID] [IN DBEFileSetName3]
CREATE TEMPSPACE
CREATE TEMPSPACE TempSpaceName WITH [MAXFILEPAGES = MaxTempFileSize,]
LOCATION ='PhysicalLocation'
CREATE VIEW
CREATE VIEW [Owner.]ViewName [( ColumnName [,...])] AS QueryExpression
[IN DBEFileSetName] [WITH CHECK OPTION [CONSTRAINT ConstraintID]]
DECLARE CURSOR
DECLARE CursorName [IN DBEFileSetName] CURSOR FOR
{{QueryExpression } [FOR UPDATE OF {ColumnName} [,...]]}
{{SelectStatementName} [FOR READ ONLY ]}
{ }
{ExecuteProcedureStatement }
{ExecuteStatementName }
DECLARE Variable
DECLARE {LocalVariable} [,...] VariableType [LANG = VariableLangName]
[ {Constant }]
[DEFAULT {NULL }] [NOT NULL]
[ {CurrentFunction}]
DELETE
[REV BEG]
DELETE [WITH AUTOCOMMIT] FROM {[Owner.]TableName} [WHERE SearchCondition]
{[Owner.]ViewName }
[REV END]
DELETE WHERE CURRENT
DELETE FROM {[Owner.]TableName} WHERE CURRENT OF CursorName
{[Owner.]ViewName }