ALLBASE/SQL Reference Manual (36216-90216)

616 AppendixA
SQL Syntax Summary
START DBE
START DBE ‘DBEnvironmentName’ [AS ‘ConnectionName’ ][MULTI]
[BUFFER = ( DataBufferPages, LogBufferPages )
TRANSACTION = MaxTransactions
MAXIMUM TIMEOUT = { TimeoutValue [SECONDS
MINUTES]
NONE }
DEFAULT TIMEOUT = { TimeoutValue [SECONDS
MINUTES]
MAXIMUM }
RUN BLOCK = ControlBlockPages ]|,...|
START DBE NEW
START DBE ‘DBEnvironmentName’ [AS ‘ConnectionName’ ][MULTI]NEW
[{DUAL
AUDIT}|...|LOG
BUFFER = ( DataBufferPages, LogBufferPages )
LANG = LanguageName
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
DBEFile0Definition
DBELogDefinition ]|,...|
DBEFile0Definition
DBEFILE0 DBEFILE DBEDile0ID
WITH PAGES = DBEFile0Size
NAME = ‘SystemFileName1’
DBELogDefinition
LOG DBEFILE DBELog1ID [AND DBELog2ID ]
WITH PAGES = DBELogSize,
NAME = ‘SystemFileName2’ [ AND ‘SystemFileName3’ ]