Disconnects a user from the specified connection.
The specified connection is disconnected. Any current transaction is rolled back, cursors are closed, and compiled statements are destroyed. No further access to the database using that connection is possible.
If the specified connection is not the current connection the application still has access to the current connection. Otherwise, to continue with another connection the application must either perform a
SET CONNECTIONor a
connectionis not case-sensitive and may be specified as a literal value or by using a host variable.
If no disconnect option is specified,
CURRENTis assumed by default.
DISCONNECTstatement may not be issued within a transaction. The transaction must first be ended using
DISCONNECTcan be performed.
ExampleDISCONNECT 'connection 1';
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40