This keyword will return a list of active CONNX connections & statements within the current process.  This is useful for diagnostics of applications and servers that manage multiple CONNX connections, such as the JDBC server, or a web server.  Individual statements returns from {showsessions} can be killed with the {killstatement} command.

 

Example:

select 1 {showsessions}