HP 3000 Manuals HP 3000 Manuals
RELEASE
The RELEASE statement terminates your DBE session.
Scope
ISQL or Application Programs
SQL Syntax
RELEASE
Description
* A ROLLBACK 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.[REV BEG]
* 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.[REV END]
Authorization
You do not need authorization to use the RELEASE statement.
Example
CONNECT TO 'PartsDBE.SomeGrp.SomeAcct'
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