Sybase IQ also gives you the ability to disconnect other
users from a given database.
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' )
Connect to an existing database with DBA authority.
Using Interactive SQL, execute a DROP CONNECTION statement.
The following statement drops the connection with ID number 4.