HP 3000 Manuals

ALLBASE/SQL Reference Manual

STOP DBE 

The STOP DBE statement concludes ALLBASE/SQL operations and shuts down
DBEnvironment operations.

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 '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.

      STOP DBE 
[REV BEG]

MPE/iX 5.5 Documentation