| | Programming Guide |
Closes all connections on an database engine
DBMS [ WITH ENGINE engine ] CLOSE_ALL_CONNECTIONS
DBMS WITH ENGINE engine- Name of engine for which connections are to be closed. If the clause is not used, Prolifics 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 closes the error handler and
// then closes all connections.proc logoff
DBMS ONERROR
DBMS CLOSE_ALL_CONNECTIONS
return
DBMS DECLARE CONNECTION, DBMS CLOSE CONNECTION, dm_is_connection