Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
DISCONNECT statementUse the DISCONNECT statement to terminate a connection between an application and a database server.

DISCONNECT statement

Use the DISCONNECT statement to terminate a connection between an application and a database server.

Syntax

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

Usage

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.