Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


DISCONNECT


Disconnects a user from the specified connection.

Usage

Embedded/Interactive.

Description

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 CONNECTION or a CONNECT statement.

The connection is not case-sensitive and may be specified as a literal value or by using a host variable.

If no disconnect option is specified, CURRENT is assumed by default.

Restrictions

None.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL92
YES
Specifying one of: connection-name, ALL, CURRENT or DEFAULT after the keyword DISCONNECT is optional in Mimer SQL, not mandatory.
Using the DISCONNECT statement on a connection that has an active transaction is not forbidden in Mimer SQL (the transaction is rolled back).



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX