RELEASE
MPE documents | |
 Complete PDF | |
| Table of Contents | |
| Index | |
| E0300 Edition 9 ♥ | |
| E0399 Edition 8 | |
| E0897 Edition 7 |
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.
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
|
REFETCH |
REMOVE DBEFILE |