STOP DBE
MPE documents | |
 Complete PDF | |
| Table of Contents | |
| Index | |
| E0300 Edition 9 ♥ | |
| E0399 Edition 8 | |
| E0897 Edition 7 |
Scope
ISQL or Application Programs
SQL Syntax
STOP DBE
Description
Any transactions in progress are aborted, but their changes are not backed out until the START DBE statement is processed.
A checkpoint is taken.
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.
STOP DBE
|
START DBE NEWLOG |
TERMINATE QUERY |