DISCONNECT

>>-DISCONNECT--+-CURRENT------------+--------------------------><
               |  (1)               |
               +--------+-ALL-----+-+
               |        '-DEFAULT-' |
               '-+-'connection'---+-'
                 '-connection_var-'

Notes:

ESQL/C only

Element	Description	Restrictions	Syntax
connection	String that specifies a connection to terminate	Connection name that the CONNECT statement assigned	Quoted String
connection_var	Host variable that holds the name of a connection	Must be a fixed-length character data type	Language specific

DISCONNECT terminates a connection to a database server. If a database is open, it closes before the connection drops. Even if you made a connection to a specific database only, the connection to the database server is terminated by DISCONNECT. If DISCONNECT does not terminate the current connection, the connection context of the current environment is not changed.

DISCONNECT is not valid as statement text in a PREPARE statement.

In ESQL/C, if you disconnect with connection or connection_var, DISCONNECT generates an error if the specified connection is not a current or dormant connection.

DISCONNECT

Syntax

Usage