| Programming Guide | |
Closes all connections on a database engine
DBMS [WITH ENGINEengine] CLOSE_ALL_CONNECTIONS
WITH ENGINEengine- 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.
When
DBMSCLOSE_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
DBMS ONERROR
DBMS CLOSE_ALL_CONNECTIONS
return
DECLARE CONNECTION,CLOSE CONNECTION,dm_is_connection