 |
» |
|
|
|
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 '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: |
