ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 479
SQL Statements E - R
RELEASE
RELEASE
The RELEASE statement terminates your DBE session.
Scope
ISQL or Application Programs
SQL Syntax
RELEASE
Description
•AROLLBACK is performed on any transactions in progress.
• Any locks still held are released. Any cursors still open are closed, including kept
cursors.
• If the AUTOSTART option is in effect and your session is the only one in process, a
RELEASE statement forces a checkpoint.
• Following a RELEASE or DISCONNECT CURRENT command, there is no current
connection until a SET CONNECTION command is used to set the current connection to
another existing connection, or a new connection is established by using the CONNECT,
START DBE, START DBE NEW, or START DBE NEW LOG commands.
Authorization
You do not need authorization to use the RELEASE statement.
Example
CONNECT TO '../sampledb/PartsDBE'
ALLBASE/SQL establishes a DBE session for you. Once you have a DBE session, you can
submit SQL statements. After submitting the statements, terminate your DBE session:
RELEASE