HP 3000 Manuals HP 3000 Manuals
SQL Syntax Summary (Continued)
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 }
DESCRIBE
[OUTPUT]
DESCRIBE [INPUT ] StatementName {INTO [[SQL] DESCRIPTOR]} {SQLDA }
[RESULT] {USING [SQL] DESCRIPTOR } {AreaName}
DISABLE AUDIT LOGGING
DISABLE AUDIT LOGGING
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]
DROP PARTITION
DROP PARTITION PartitionName
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
ENABLE AUDIT LOGGING
ENABLE AUDIT LOGGING
ENABLE RULES
ENABLE RULES
END DECLARE SECTION
END DECLARE SECTION
EXECUTE
EXECUTE {StatementName }
{[Owner.]ModuleName [(SectionNumber)]}
[ { {[INPUT] {SQLDA } }}]
[ { { {AreaName1} }}]
[ { { }}]
[ {[SQL] DESCRIPTOR{[AND OUTPUT {SQLDA }]}}]
[ { {[ {AreaName2}]}}]
[ { { }}]
[USING { {OUTPUT {SQLDA } }}]
[ { { {AreaName} }}]
[ { }]
[ {[INPUT] HostVariableSpecification1 }]
[ {[AND OUTPUT HostVariableSpecification2] }]
[ {OUTPUT HostVariableSpecification }]
[ {:Buffer [,:StartIndex [, :NumberOfRows]] }]
HostVariableSpecification.
:HostVariableName[[INDICATOR] :IndicatorVariable] [,...]
EXECUTE IMMEDIATE
EXECUTE IMMEDIATE {'String' }
{:HostVariable}
EXECUTE PROCEDURE
EXECUTE PROCEDURE [:ReturnStatusVariable =] [Owner.]ProcedureName
[( [ActualParameter] [, [ActualParameter]][...] )]
ActualParameter.
[ParameterName =] ParameterValue [OUTPUT [ONLY]]
FETCH
{INTO HostVariableSpecification }
{ {[SQL]DESCRIPTOR {SQLDA }}}
[BULK] FETCH CursorName {USING { {AreaName}}}
{ { }}
{ {HostVariableSpecification }}
BULK HostVariableSpecification.
:Buffer [,:StartIndex [,:NumberOfRows]]
Non-BULK HostVariableSpecification.
{:HostVariable [[INDICATOR] :Indicator]} [,...]
[REV BEG]
GENPLAN
GENPLAN [WITH (HostVariableDefinition)] FOR
{SQLStatement }
{MODULE SECTION [Owner.] ModuleName(SectionName) }
{PROCEDURE SECTION [Owner.] ProcedureName(SectionName)}
[REV END]
GOTO
{GOTO } {Label }
{GO TO} {Integer}
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}]
Grant RUN or EXECUTE Authority.
{{DBEUserID} }
GRANT {RUN ON [Owner.]ModuleName } TO {{GroupName} [,...]}
{EXECUTE ON PROCEDURE [Owner.]ProcedureName} {{ClassName} }
{PUBLIC }
[REV BEG]
Grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority.
{CONNECT }
{DBA } {DBEUserID}
GRANT{INSTALL [AS OwnerID]}TO {GroupName}[,...]
{MONITOR } {ClassName}
{RESOURCE }
[REV END]
Grant DBEFileSet Authority.
{DBEUserID}
GRANT {SECTIONSPACE} [,...] ON DBEFILESET DBEFileSetName TO {GroupName}
{TABLESPACE } {ClassName}
{PUBLIC }
[,...]
IF
IF Condition THEN [Statement;[...]]
[ELSEIF Condition THEN [Statement; [...]]] [ELSE [Statement; [...]]]
ENDIF;
INCLUDE
INCLUDE {SQLCA [[IS] EXTERNAL]}
{SQLDA }
INSERT - 1
[BULK] INSERT INTO {[Owner.]TableName} [({ColumnName} [,...])] VALUES
{[Owner.]ViewName }
{SingleRowValues}
({BulkValues })
{? }
SingleRowValues.
{NULL }
{USER }
{:HostVariable [[INDICATOR] :IndicatorVariable]}
{? }
{:LocalVariable }
{:ProcedureParameter }
{::Built-inVariable }
{ConversionFunction } [,...]
{CurrentFunction }
{ {Integer} }
{[+] {Float } }
{[-] {Decimal} }
{ }
{'CharacterString' }
{0xHexadecimalString }
{'LongColumnIOString' }
LongColumnIOString.
[{> } {FileName[.Group[.Account]]}]
[{>>} {CharString$ }]
< {FileName[.Group[.Account]]} [{>!} {CharString$CharString }]
{%HeapAddress:LengthofHeap } [ ]
[>%$ ]
BulkValues.
:Buffer [,:StartIndex [, :NumberOfRows]]
Dynamic Parameter Substitution.
(? [,...] )
INSERT - 2
INSERT INTO {[Owner.]TableName} [(ColumnName [,...])] QueryExpression
{[Owner.]ViewName }
Labeled Statement
Label: Statement
LOCK TABLE
LOCK TABLE [Owner.]TableName IN {SHARE [UPDATE]} MODE
{EXCLUSIVE }
LOG COMMENT
{'String' }
{:HostVariable }
LOG COMMENT {:ProcedureParameter }
{:ProcedureLocalVariable}
{? }
OPEN
OPEN CursorName [KEEP CURSOR [WITH LOCKS ]]
[ [WITH NOLOCKS]]
[ {[SQL] DESCRIPTOR{SQLDA } }]
[USING { {AreaName} }]
[ { }]
[ {HostVariableName[[INDICATOR] :IndicatorVariable] [,...]}]
PREPARE
PREPARE [REPEAT] {StatementName }
{[Owner.]ModuleName [(SectionNumber)]}
[IN DBEFileSetName] FROM {'String' }
{:HostVariable}
PRINT
{'Constant' }
PRINT {:LocalVariable };
{:Parameter }
{::Built-inVariable}
RAISE ERROR
RAISE ERROR [ErrorNumber] [MESSAGE ErrorText]