ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 571

SQL Statements S - Z

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