When you are finished working with a database, you can disconnect from it. Sybase IQ also gives you the ability to disconnect other users from a given database; for more information about doing this in Sybase Central, see Introduction to Sybase IQ.
You can obtain the connection-id for a user by using the connection_property function to request the connection number. The following statement returns the connection ID of the current connection:
SELECT connection_property( 'number' )
Disconnecting from a database (Sybase Central)
Open the desired server.
Select the desired database.
On the toolbar, click the Disconnect button.
Disconnecting from a database (SQL)
Execute a DISCONNECT statement.
The following statement shows how to use DISCONNECT from Interactive SQL to disconnect all connections:
DISCONNECT ALL
The following statement shows how to use DISCONNECT in Embedded SQL:
EXEC SQL DISCONNECT :conn_name
Disconnecting other users from a database (SQL)
Connect to an existing database with DBA authority.
Execute a DROP CONNECTION statement.
The following statement drops the connection with ID number 4.
DROP CONNECTION 4
For more information, see “DISCONNECT statement [DBISQL]” and “DROP CONNECTION statement” in Sybase IQ Reference Manual.
