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 Java, a user selects SQL > Disconnect (or Command→Disconnect in Interactive SQL Classic)
In Sybase Central, a user selects Tools > Disconnect
An application with active connections, such as DBISQL or Sybase Central, is closed
Users with DBA authority can also drop a specific connection:
In DBISQL or Embedded SQL, by issuing a DROP CONNECTION statement
In Sybase Central, by accessing the Connected Users folder for the database
For more about displaying connection IDs and active connection information, see “sp_iqconnection procedure” in Sybase IQ Reference Manual. See Sybase IQ Reference Manual Chapter 6, “SQL Statements” for the DISCONNECT and DROP CONNECTION statements. For information on Sybase Central, see Chapter 4, “Managing Databases” in Introduction to Sybase IQ.
