DISCONNECT
Disconnects
the active database connection.
SYNTAX
DESCRIPTION
The DISCONNECT
command closes the active database connection. This command does not affect
other database connections for the same user that are not active. Any
user with CONNECT or higher security privileges can execute the DISCONNECT
command.
A transaction
is traditionally defined as a logical unit of work, or one or more operations
on a database that must be completed together to leave the database in
a consistent state. Transactions are self-contained and must either complete
successfully and change the data, or fail and leave the data unchanged.
If a transaction
completes successfully and changes the data, we say it has been committed.
If a transaction fails and leaves the data unchanged, we say it has been
rolled back.
AUTOCOMMIT
mode controls when DBMaker will commit a transaction. When AUTOCOMMIT
mode is on, each command is treated as a separate transaction. DBMaker
automatically commits each command you execute if it completes successfully,
or rolls it back if an error occurs during execution. When AUTOCOMMIT
mode is off, all commands between successive COMMIT WORK commands form
a single transaction.
Executing
the COMMIT WORK command commits any changes made in the transaction, and
executing the ROLLBACK WORK command rolls back all changes.
When you
disconnect from a database and AUTOCOMMIT mode is off, the active transaction
will be aborted. Any changes made by the transaction will not be recorded
in the database.
When you
disconnect from a multi-user database, the database remains active and
accessible to other users. When you disconnect from a single-user database
running on UNIX the database will shut down, When you disconnect from
a multiple-connection database running on Windows the database will shut
down only if you are the last connected user. Otherwise the database will
remain active as long as other users are connected.
EXAMPLE
The following
example disconnects the active database connection.
RELATED COMMANDS
<
DELETE | Contents
| DROP COMMAND >
|
