DISCONNECT Statement [Interactive SQL]

Quick Links:

Syntax

DISCONNECT [ { connection-name | CURRENT | ALL } ]

Parameters

(back to top)

connection-name – identifier, string, or host-variable

ALL – drops all of the connections of the application to all database environments.

CURRENT – (default) Drops the current connection.

Examples

(back to top)

Example 1 – how to use DISCONNECT in Embedded SQL:
```
EXEC SQL DISCONNECT :conn_name
```
Example 2 – how to use DISCONNECT from dbisql to disconnect all connections:
```
DISCONNECT ALL
```

Usage

(back to top)

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, then the name can be specified.

An implicit ROLLBACK is executed on connections that are dropped.

Standards

(back to top)

SQL—ISO/ANSI SQL compliant.
SAP Sybase Database product—Supported by Open Client/Open Server.

Permissions

(back to top)

None