The STOP DBE statement concludes ALLBASE/SQL operations and shuts
down DBEnvironment operations.
Scope |
 |
ISQL or Application Programs
SQL Syntax |
|
Description |
|
Any transactions in progress are aborted,
but their changes are not backed out until the START DBE statement is processed.
Any locks still held are released. Any cursors still
open are closed.
Authorization |
|
You must have DBA authority to use this statement.
Example |
|
Two users establish DBE sessions.
CONNECT TO '../sampledb/PartsDBE'
CONNECT TO '../sampledb/PartsDBE' |
The DBA shuts down ALLBASE/SQL, and the two DBE sessions are
aborted. Any incomplete transactions are rolled back when the DBEnvironment
is next started up.
