RELEASE

The RELEASE session management statement releases a connection to a CA IDMS dictionary and ends the SQL session. It is also a CA IDMS extension of the SQL standard.
idmscu19
The RELEASE session management statement releases a connection to a CA IDMS dictionary and ends the SQL session. It is also a CA IDMS extension of the SQL standard.
Authorization
None required.
Syntax
►►─── RELEASE ────────────────────────────────────────────────────────────────►◄
Usage
Ending an SQL Session
To end an SQL session established with the CONNECT statement, you must use one of the following statements:
  • RELEASE
  • COMMIT RELEASE
  • ROLLBACK RELEASE
To end an SQL Session established automatically, you can use any of the above statements or COMMIT or ROLLBACK without the RELEASE parameter.
Automatic Rollback
When ending an SQL session, CA IDMS automatically rolls back any transaction that is still active.
Example
Releasing a Connection
The following RELEASE statement ends the current SQL session and releases the connection with the dictionary:
EXEC SQL    RELEASE END-EXEC
More Information