ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 617
SQL Syntax Summary
START DBE NEWLOG
START DBE ‘DBEnvironmentName’ [AS ‘ConnectionName’ ][MULTI]NEWLOG
[{ARCHIVE
DUAL
AUDIT}|...|LOG
BUFFER =( DataBufferPages, LogBufferPages )
TRANSACTION = MaxTransactions
MAXIMUM TIMEOUT = { TimeoutValue [SECONDS
MINUTES]
NONE }
DEFAULT TIMEOUT = { TimeoutValue [SECONDS
MINUTES]
MAXIMUM }
RUN BLOCK = ControlBlockPages
DEFAULT PARTITION = { DefaultPartitionNumber
NONE }
COMMENT PARTITION = { CommentPartitionNumber
DEFAULT
NONE }
MAXPARTITIONS = MaximumNumberOfPartitions
AUDIT NAME = ‘AuditName’
{COMMENT
DATA
DEFINITION
STORAGE
AUTHORIZATION
SECTION
ALL }|...|AUDIT ELEMENTS ]|,...| NewLogDefinition
NewLogDefinition
LOG DBEFILE
DBELog1ID [AND DBELog2ID ]
WITH PAGES =
DBELogSize ,
NAME = '
SystemFileName1 ' [AND ' SystemFileName2 ']
STOP DBE
STOP DBE
TERMINATE QUERY
TERMINATE QUERY FOR {CID ConnectionID
XID TransactionID }
TERMINATE TRANSACTION
TERMINATE TRANSACTION FOR {CID ConnectionID
XID TransactionID }