Reference Manual
   CHAPTER 9. SQL Statements     

DISCONNECT statement [ESQL][ISQL]

Function 

To drop a connection with the database.

Syntax 

DISCONNECT
connection-name
| [ CURRENT ]
| ALL

Parameters 

connection-name: identifier, string, or host-variable.

Permissions 

None.

Side effects 

None.

See also 

CONNECT statement

SET CONNECTION statement

Description 

The DISCONNECT statement drops a connection with the database server and releases all resources used by it. If the connection to be dropped was named on the CONNECT statement, the name can be specified. Specifying ALL will drop all of the application's connections to all database environments. CURRENT is the default, and will drop the current connection.

An implicit ROLLBACK is executed on connections that are dropped.

Standards and compatibility 

• SQL/92     Intermediate level feature.

• Sybase     Supported by Open Client/Open Server.

Examples 

• The following statement shows how to use DISCONNECT in Embedded SQL:

  EXEC SQL DISCONNECT :conn_name

• The following statement shows how to use DISCONNECT from Interactive SQL to disconnect all connections:

  DISCONNECT ALL