ASA SQL Reference
  SQL Statements

DISCONNECT statement [ESQL] [Interactive SQL]

Description 

Use this statement to drop the current connection to a database.

Syntax 

DISCONNECT [ connection-name | CURRENT | ALL ]

connection-name : identifier, string, or hostvar

Usage 

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.

For information on dropping connections other than the current connection, see DROP CONNECTION statement.

Permissions 

None.

Side effects 

None.

See also 

CONNECT statement [ESQL] [Interactive SQL]

SET CONNECTION statement [Interactive SQL] [ESQL]

Standards and compatibility 

• SQL/92    Intermediate-level feature.

• SQL/99    SQL/foundation feature outside of core SQL.

• Sybase    Supported by Open Client/Open Server.

Example 

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