SQL Syntax Summary (Continued) [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
SQL Syntax Summary (Continued)
START DBE NEW
START DBE 'DBEnvironmentName' [AS 'ConnectionName'] [MULTI] NEW
[{DUAL } |...| LOG ]
[{AUDIT} ]
[ ]
[BUFFER = (DataBufferPages, LogBufferPages) ]
[LANG = LanguageName ]
[TRANSACTION = MaxTransactions ]
[ {TimeoutValue [SECONDS]} ]
[MAXIMUM TIMEOUT = { [MINUTES]} ]
[ { } ]
[ {NONE } ]
[ ]
[ {TimeoutValue [SECONDS]} ]
[DEFAULT TIMEOUT = { [MINUTES]} ]
[ { } ]
[ {MAXIMUM } ]
[ ]
[RUN BLOCK = ControlBlockPages ]
[DEFAULT PARTITION = {DefaultPartitionNumber}] |,...|
[ {NONE }]
[ ]
[ {CommentPartitionNumber}]
[COMMENT PARTITION = {DEFAULT }]
[ {NONE }]
[ ]
[MAXPARTITIONS = MaximumNumberOfPartitions ]
[AUDIT NAME = 'AuditName' ]
[{COMMENT } ]
[{DATA } ]
[{DEFINITION } ]
[{STORAGE } |...| AUDIT ELEMENTS ]
[{AUTHORIZATION} ]
[{SECTION } ]
[{ALL } ]
[ ]
[DBEFile0Definition ]
[DBELogDefinition ]
DBEFile0Definition.
DBEFILE0 DBEFILE DBEFile0ID WITH PAGES = DBEFile0Size, NAME =
'SystemFileName1'
DBELogDefinition.
LOG DBEFILE DBELog1ID [AND DBELog2ID] WITH PAGES = DBELogSize, NAME =
'SystemFileName2' [AND 'SystemFileName3']
START DBE NEWLOG
START DBE 'DBEnvironmentName' [AS 'ConnectionName'] [MULTI] NEWLOG
[{ARCHIVE} ]
[{DUAL } |...| LOG ]
[{AUDIT } ]
[ ]
[BUFFER = (DataBufferPages, LogBufferPages) ]
[TRANSACTION = MaxTransactions ]
[ {TimeoutValue [SECONDS]} ]
[MAXIMUM TIMEOUT = { [MINUTES]} ]
[ { } ]
[ {NONE } ]
[ ]
[ {TimeoutValue [SECONDS]} ]
[DEFAULT TIMEOUT = { [MINUTES]} ]
[ { } ]
[ {MAXIMUM } ]
[ ]
[RUN BLOCK = ControlBlockPages ] |,...| NewLogDefinition
[DEFAULT PARTITION = {DefaultPartitionNumber}]
[ {NONE }]
[ ]
[ {CommentPartitionNumber}]
[COMMENT PARTITION = {DEFAULT }]
[ {NONE }]
[ ]
[MAXPARTITIONS = MaximumNumberOfPartitions ]
[AUDIT NAME = 'AuditName' ]
[{COMMENT } ]
[{DATA } ]
[{DEFINITION } ]
[{STORAGE } |...| AUDIT ELEMENTS ]
[{AUTHORIZATION} ]
[{SECTION } ]
[{ALL } ]
NewLogDefinition.
LOG DBEFILE DBELog1ID [AND DBELog2ID] WITH PAGES = DBELogSize, NAME =
'SystemFileName1' [AND 'SystemFileName2']
STOP DBE
STOP DBE
[REV BEG]
TERMINATE QUERY
TERMINATE QUERY FOR {CID ConnectionID }
{XID TransactionID}
[REV END][REV BEG]
TERMINATE TRANSACTION
TERMINATE TRANSACTION FOR {CID ConnectionID }
{XID TransactionID}
TERMINATE USER
{DBEUserID }
TERMINATE USER {SessionID }
{CID ConnectionID}
[REV END]
TRANSFER OWNERSHIP
{[TABLE] [Owner.]TableName }
TRANSFER OWNERSHIP OF {[VIEW] [Owner.]ViewName } TO NewOwnerName
{PROCEDURE [Owner.]ProcedureName}
{GROUP GroupName }
TRUNCATE TABLE
TRUNCATE TABLE [Owner.]TableName
UPDATE
{ {Expression }}
UPDATE {[Owner.]TableName} SET {ColumnName = {'LongColumnIOString'}}
{[Owner.]ViewName } { {NULL }}
[,...] [WHERE SearchCondition]
LongColumnIOString.
{[< {FileName[.Group[.Account]]}] }
{[ {%HeapAddress:LengthofHeap }] }
{ }
{[{> } {FileName[.Group[.Account]]}]} |...|
{[{>>} {CharString$ }]}
{[{>!} {CharString$CharString }]}
{[ ]}
{[>%$ ]}
UPDATE STATISTICS
UPDATE STATISTICS FOR TABLE {[Owner.]TableName }
{SYSTEM.SystemViewName}
UPDATE WHERE CURRENT
{ {Expression }}
UPDATE {[Owner.]TableName} SET {ColumnName = {'LongColumnIOString'}}
{[Owner.]ViewName } { {NULL }}
[,...] WHERE CURRENT OF CursorName
LongColumnIOString.
{[< {FileName[.Group[.Account]]}] }
{[ {%HeapAddress:LengthofHeap }] }
{ }
{[{> } {FileName[.Group[.Account]]}]} |...|
{[{>>} {CharString$ }]}
{[{>!} {CharString$CharString }]}
{[ ]}
{[>%$ ]}
[REV BEG]
VALIDATE
VALIDATE [FORCE ]
[DROP SETOPTINFO]
{MODULE {{[Owner.]ModuleName}[,...] } }
{ {{SECTION [Owner.]ModuleName (Section Number)}[,...]} }
{ }
{PROCEDURE {{[Owner.]ProcedureName}[,...] }}
{ {{SECTION [Owner.]ProcedureName (Section Number)}[,...]}}
{ }
{ALL {MODULES } [WITH AUTOCOMMIT] }
{ {PROCEDURES} }
[REV END]
WHENEVER
{SQLERROR } {STOP }
WHENEVER {SQLWARNING} {CONTINUE }
{NOT FOUND } {GOTO [:] Label }
{GO TO [:] Label}
WHILE
WHILE Condition DO [Statement; [...]] ENDWHILE;
MPE/iX 5.5 Documentation