ALLBASE/SQL Reference Manual (36216-90216)
552 Chapter12
SQL Statements S - Z
START DBE
START DBE
The START DBE statement establishes a connection with a given DBEnvironment and
establishes a set of startup parameters that apply to this and all subsequent connections
until all connections to the DBEnvironment have been terminated. Any startup
parameters not explicitly specified are taken from the DBECon file. The changes are only
temporary for START DBE parameters; use START DBE NEW to specify the start up
parameters to be stored in the DBECon file in a new DBE. Use SQLUtil to change the
parameters in the DBECon file in an existing DBE.
Scope
ISQL or Application Programs
SQL Syntax
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
]|,...|
Parameters
DBEnvironmentName
identifies the DBEnvironment in which the session is established.
Unless you specify an absolute path name, the name you specify is
assumed to be relative to your current working directory.
ConnectionName
associates a user specified name with this connection.
ConnectionName
must be unique for each DBEnvironment connection
within an application or an ISQL session. If a
ConnectionName
is not
specified,
DBEnvironmentName
is the default.
ConnectionName
cannot
exceed 128 bytes.
MULTI indicates the DBEnvironment can be accessed by multiple users
simultaneously. If omitted, the DBEnvironment can be accessed only by
the user issuing the START DBE statement. If the MULTI option is
specified, other users can start DBE sessions by using the CONNECT
statement.
DataBufferPages
specifies the number of 4096-byte data buffer pages to be used. Data
buffer pages hold index and data pages.
You can request up to 50,000 data buffer pages. The minimum number of
data buffers is 15. The default number is 100. The total number of data
buffer pages and runtime control block pages cannot exceed 256 Mbytes.