Statements › RELEASE

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.

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

• For more information about establishing a database connection and beginning an SQL session, see CONNECT.
• For more information about managing SQL sessions, see the CA IDMS SQL Programming Guide.