Programming Guide



CLOSE_ALL_CONNECTIONS

Closes all connections on an database engine

Synopsis

DBMS [ WITH ENGINE engine ] CLOSE_ALL_CONNECTIONS

Arguments

DBMS WITH ENGINE 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.

Description

When DBMS CLOSE_ALL_CONNECTIONS is 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.

Example

// This procedure closes the error handler and 
// then closes all connections.
proc logoff
DBMS ONERROR
DBMS CLOSE_ALL_CONNECTIONS
return

See Also

DECLARE CONNECTION, CLOSE CONNECTION, dm_is_connection