ALLBASE/SQL Reference Manual (36216-90216)

554 Chapter12
SQL Statements S - Z
START DBE
CONNECT statement.
• Timeout values set in the START DBE statement remain in effect only as long as there is
a session established for connected DBEnvironments and do not modify the values
stored in the DBECon file.
• If no MAXIMUM TIMEOUT limit is specified, the MAXIMUM TIMEOUT limit stored
in the DBECon file remains in effect. If no DEFAULT TIMEOUT value is specified, the
DEFAULT TIMEOUT value stored in the DBECon file remains in effect.
• If MAXIMUM TIMEOUT = NONE, infinity (no timeout) is assumed. If DEFAULT
TIMEOUT = MAXIMUM, the value of MAXIMUM TIMEOUT is assumed. The
DEFAULT TIMEOUT value may not exceed the MAXIMUM TIMEOUT value.
• No connections to the DBEnvironment can be in effect when this command is issued.
• The START DBE statement is also used before using the START DBE NEWLOG
statement. Refer to the START DBE NEWLOG statement for additional information.
Authorization
You can issue the START DBE statement only if you have DBA authority.
Example
The sample DBEnvironment is started in single-user mode. All parameters except the user
mode in the DBECon file are used for the duration of the single-user session. After this
session ends, a CONNECT statement can be used to establish a multiuser session for this
DBEnvironment, because the user mode in the DBECon file is still multiuser and the
autostart flag is still ON.
START DBE '../sampledb/PartsDBE'