Closes all connections on a database 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 ENGINEclause and issue the statement for each engine used in the application.
// This procedure unsets the error handler and
// then closes all connections.proc logoff