RELEASE

The RELEASE statement places one or more connections in the release-pending state. If the RELEASE statement is successful, each identified connection is placed in the release-pending state and will therefore be ended during the next commit operation. If the RELEASE statement is unsuccessful, the connection state of the activation group and the states of its connections are unchanged.

You may specify a server name, the current connection of the activation group, or all of the existing connections of the activation group.

Example:

The connection to NEWYORK is not needed in the next unit of work. The following statement will cause it to be ended during the next commit operation.

RELEASE NEWYORK
The current connection is no longer needed.
RELEASE CURRENT
All existing connections are no longer needed.
RELEASE ALL

For more information, see RELEASE in the SQL Reference topic in the Information CenterLink to Information center.