SQL Syntax Summary (Cont.) [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
SQL Syntax Summary (Cont.)
REFETCH
REFETCH CursorName INTO {:HostVariable [[INDICATOR] :Indicator]} [,...]
RELEASE
RELEASE
REMOVE DBEFILE
REMOVE DBEFILE DBEFileName FROM DBEFILESET DBEFileSetName
REMOVE FROM GROUP
{DBEUserID}
REMOVE {GroupName} [,...] FROM GROUP [Owner.]TargetGroupName
{ClassName}
[REV BEG]
RENAME COLUMN
RENAME COLUMN [Owner.]TableName.ColumnName TO NewColumnName
RENAME TABLE
RENAME TABLE [Owner.] TableName TO NewTableName
[REV END]
RESET
{SYSTEM.ACCOUNT [FOR USER {* }]}
RESET { [ {DBEUserID}]}
{ }
{SYSTEM.COUNTER }
RETURN
RETURN [ReturnStatus];
REVOKE
Revoke Table or View Authority.
{ALL [PRIVILEGES] }
{[SELECT ] }
{[INSERT ] }
REVOKE {[DELETE ] } ON
{[ALTER ] |,...|}
{[INDEX ] }
{[UPDATE [({ColumnName} [,...])] ] }
{[REFERENCES [({ColumnName} [,...])]] }
{DBEUserID}
{[Owner.]TableName} FROM {GroupName} [,...] [CASCADE]
{[Owner.]ViewName } {ClassName}
{PUBLIC }
Revoke RUN or EXECUTE or Authority.
REVOKE [RUN ON [Owner.]ModuleName ] FROM
[EXECUTE ON PROCEDURE [Owner.]ProcedureName]
{{DBEUserID} }
{{GroupName} [,...]}
{{ClassName} }
{PUBLIC }
[REV BEG]
Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority.
{CONNECT }
{DBA } {DBEUserID}
REVOKE {INSTALL [AS OwnerID]} FROM {GroupName} [,...]
{MONITOR } {ClassName}
{RESOURCE }
[REV END]
SQL Syntax--Revoke DBEFileSet Authority.
REVOKE {SECTIONSPACE} |,...| ON DBEFILESET DBEFileSetName FROM
{TABLESPACE }
{{DBEUserID} }
{{GroupName} [,...]}
{{ClassName} }
{PUBLIC }
ROLLBACK WORK
[ {SavePointNumber }]
[TO {:HostVariable }]
ROLLBACK WORK [ {:LocalVariable }]
[ {:ProcedureParameter}]
[ ]
[RELEASE ]
SAVEPOINT
[:HostVariable ]
SAVEPOINT [:LocalVariable ]
[:ProcedureParameter]
SELECT
Select Statement Level.
[BULK] QueryExpression [ORDER BY {ColumnID [ASC ]} [,...]]
[ { [DESC]} ]
Subquery Level.
(QueryExpression)
Query Expression Level.
{QueryBlock } [UNION [ALL] {QueryBlock }] [...]
{(QueryExpression)} [ {(QueryExpression)}]
Query Block Level.
SELECT [ALL ] SelectList [INTO HostVariableSpecification] FROM
[DISTINCT]
FromSpec [,...] [WHERE SearchCondition1] [GROUP BY GroupColumnList]
[HAVING SearchCondition2]
SelectList.
{* }
{[Owner.]Table.* }
{CorrelationName.* } [,...]
{Expression }
{[[Owner.]Table.]ColumnName}
{CorrelationName.ColumnName}
HostVariableSpecification--With BULK Option.
:Buffer [,:StartIndex [,:NumberOfRows]]
HostVariableSpecification--Without BULK Option.
{:HostVariable [[INDICATOR] :Indicator]} [,...]
FromSpec.
{TableSpec }
{(FromSpec) }
{ [INNER ] }
{FromSpec NATURAL [LEFT [OUTER] ] JOIN {TableSpec } }
{ [RIGHT [OUTER]] {(FromSpec)} }
{ }
{ [INNER ] }
{FromSpec [LEFT [OUTER] ] JOIN {TableSpec } {ON SearchCondition3}}
{ [RIGHT [OUTER]] {(FromSpec)} {USING (ColumnList) }}
TableSpec.
[Owner.]TableName [CorrelationName]
SET CONNECTION
SET CONNECTION {'ConnectionName'}
{:HostVariable }
SET CONSTRAINTS
SET ConstraintType [,...] CONSTRAINTS {DEFERRED }
{IMMEDIATE}
SET DEFAULT DBEFILESET
SET DEFAULT {SECTIONSPACE} TO DBEFILESET DBEFileSetName FOR PUBLIC
{TABLESPACE }
SET DML ATOMICITY
SET DML ATOMICITY AT {ROW } LEVEL
{STATEMENT}
SET MULTITRANSACTION
SET MULTITRANSACTION {ON }
{OFF}
SETOPT
{CLEAR }
{GENERAL {ScanAccess } [,...] }
SETOPT { {JoinAlgorithm} }
{BEGIN {GENERAL {ScanAccess }} [;...] END}
{ { {JoinAlgorithm}} }
Scan Access.
{SERIALSCAN}
[NO] {INDEXSCAN }
{HASHSCAN }
{SORTINDEX }
Join Algorithm.
{NESTEDLOOP}
[NO] {NLJ }
{SORTMERGE }
{SMJ }
SET PRINTRULES
SET PRINTRULES [ON ]
[OFF]
SET SESSION
[REV BEG]
{ {RR } }
{ {CS } }
{ {RC } }
{ {RU } }
{ISOLATION LEVEL {REPEATABLE READ } }
{ {SERIALIZABLE } }
{ {CURSOR STABILITY} }
{ {READ COMMITTED } }
{ {READ UNCOMMITTED} }
{ {:HostVariable1 } }
{ }
{PRIORITY {Priority } }
{ {:HostVariable2} }
{ }
{LABEL {'LabelString' } }
{ {:HostVariable3} }
{ }
{ConstraintType [,...] CONSTRAINTS {DEFERRED }}
{ {IMMEDIATE}}
{ }
SET SESSION {DML ATOMICITY AT {STATEMENT} LEVEL } [,...]
{ {ROW } }
{ }
{ON {TIMEOUT } ROLLBACK {QUERY } }
{ {DEADLOCK} {TRANSACTION} }
{ }
{ {DEFAULT }}
{ {MAXIMUM }}
{ {TimeoutValue [{SECONDS}] }}
{USER TIMEOUT [TO] { [{MINUTES}] }}
{ { }}
{ {:HostVariable4[{SECONDS}]}}
{ { [{MINUTES}]}}
{ }
{ {SESSION } }
{TERMINATION AT {TRANSACTION} LEVEL }
{ {QUERY } }
{ {RESTRICTED } }
{ }
{[{PARALLEL}] FILL }
{[{NO }] }
[REV END][REV BEG]
SET TRANSACTION
{ {RR } }
{ {CS } }
{ {RC } }
{ {RU } }
{ISOLATION LEVEL {REPEATABLE READ } }
{ {SERIALIZABLE } }
{ {CURSOR STABILITY} }
{ {READ COMMITTED } }
{ {READ UNCOMMITTED} }
{ {:HostVariable1 } }
{ }
{PRIORITY {Priority } }
{ {:HostVariable2} }
{ }
{LABEL {'LabelString' } }
{ {:HostVariable3} }
{ }
{ConstraintType [,...] CONSTRAINTS {DEFERRED }}
SET TRANSACTION { {IMMEDIATE}} [,...]
{ }
{DML ATOMICITY AT {STATEMENT} LEVEL }
{ {ROW } }
{ }
{ON {TIMEOUT } ROLLBACK {QUERY } }
{ {DEADLOCK} {TRANSACTION} }
{ }
{ {DEFAULT } }
{ {MAXIMUM } }
{ {TimeoutValue [{SECONDS}] } }
{USER TIMEOUT [TO]{ [{MINUTES}] } }
{ { } }
{ {:HostVariable4[{SECONDS}]} }
{ { [{MINUTES}]} }
{ }
{ {SESSION } }
{TERMINATION AT {TRANSACTION} LEVEL }
{ {QUERY } }
{ {RESTRICTED } }
[REV END]
SET USER TIMEOUT
{{TimeoutValue } [SECONDS]}
{{:HostVariable} [MINUTES]}
SET USER TIMEOUT [TO] { }
{DEFAULT }
{MAXIMUM }
SQLEXPLAIN
SQLEXPLAIN :HostVariable
START DBE
START DBE 'DBEnvironmentName' [AS ConnectionName'] [MULTI]
[BUFFER = (DataBufferPages, LogBufferPages)]
[TRANSACTION = MaxTransactions ]
[ {TimeoutValue [SECONDS]}]
[MAXIMUM TIMEOUT = { [MINUTES]}]
[ { }]
[ {NONE }]
[ ] |,...|
[ {TimeoutValue [SECONDS]}]
[DEFAULT TIMEOUT = { [MINUTES]}]
[ { }]
[ {MAXIMUM }]
[ ]
[RUN BLOCK = ControlBlockPages ]
MPE/iX 5.5 Documentation