ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 555
SQL Statements S - Z
START DBE NEW
START DBE NEW
The START DBE NEW statement configures and establishes a connection with a new
DBEnvironment. It establishes a set of startup parameters that apply to this and all
subsequent connections until all connections to the DBEnvironment have been
terminated. Startup parameters are also stored in the DBECon file.
Scope
ISQL or Application Programs
SQL Syntax — 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 ]|,...|
Parameters — START DBE NEW
DBEnvironmentName identifies the DBEnvironment name used in the CONNECT
statement. This name also identifies the DBECon file that stores the
values of all parameters specified in the START DBE NEW statement that
are also used in the CONNECT statement. Unless you specify an absolute
path name, ALLBASE/SQL assumes the name is relative to your current
working directory.
ConnectionName associates a user specified name with this connection.