User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To drop a connection with the database.

Syntax

     DISCONNECT
          connection-name
          | [ CURRENT ]
          | ALL

Parameters

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

Usage

ISQL.

Permissions

None.

Side effects

None.

See also

• CONNECT statement
• SET CONNECTION statement

Description

The DISCONNECT statement drops a connection with the database engine 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. 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.

Embedded SQL Example

     EXEC SQL DISCONNECT :conn_name

ISQL Example

     DISCONNECT ALL