Closes all connections on an database engine
DBMS [ WITH ENGINE
DBMS WITH ENGINE
- Name of engine for which connections are to be closed. If the clause is not used, Panther closes all the connections on the default engine.
CLOSE_ALL_CONNECTIONSis executed, every connection which the application declared either on the named database engine or on the default engine closes. For each connection, it closes all cursors belonging to the connection, disconnects from the database engine, and frees all structures associated with the connection.
If the application accesses multiple engines, include the WITH ENGINE clause and issue the statement for each engine used in the application.
// This procedure closes the error handler and
// then closes all connections.proc logoff
DECLARE CONNECTION, CLOSE CONNECTION, dm_is_connection