 |
» |
|
|
|
The RELEASE statement terminates your DBE session. Scope | |
ISQL or Application Programs SQL Syntax | |
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. 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: |
