Drops the current connection to a database.
disconnect [ connection_name | from ASE | all ] connection_name : identifier , string, or hostvar
connection_name – the login name you are using to make the connection.
from ASE – indicates that you are disconnecting the current Adaptive Server connection.
all – indicates that you are disconnecting all connections.
identifier – the identifier you are using for the connection information.
string – the string you are using for the connection information.
hostvar – variable information for the host name and port.
Disconnects all connections:
disconnect all
disconnect drops a connection to the database server and releases all resources used by it. If the connection to be dropped was named on the connect statement, the name can be specified. Specifying all drops all of the application’s connections to all database environments. current is the default, and drops the current connection.
An implicit rollback is executed on connections that are dropped.
Any user can run this command.
None.
connect, set connection