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 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.
