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 'PartsDBE.SomeGrp.SomeAcct'
CONNECT TO 'PartsDBE.SomeGrp.SomeAcct'
|
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.