Connections end when:
In Interactive SQL or Embedded SQL, a user or application issues an explicit DISCONNECT statement for the current connection, a specified connection, or all connections for that application
In Interactive SQL, a user selects SQL > Disconnect
In Sybase Central, a user selects Connections > Disconnect
An application with active connections, such as Interactive SQL or Sybase Central, is closed
Users with DBA authority can also drop a specific connection:
In Interactive SQL or Embedded SQL, by issuing a DROP CONNECTION statement
In Sybase Central, by accessing the Users & Groups folder for the database
For more about displaying connection IDs and active connection information, see “sp_iqconnection procedure” in Reference: Building Blocks, Tables, and Procedures. For statement syntax, see DISCONNECT statement [DBISQL] and DROP CONNECTION statement in Reference: Statements and Options. For information on Sybase Central, see Chapter 4, “Managing Databases” in Introduction to Sybase IQ.
