Closes a declared connection
DBMS CLOSE CONNECTION [
- Name of connection to be closed. If connection name is not included, the default connection is closed.
CLOSE CONNECTIONcloses all open cursors associated with the named or default connection, logs off the connection from its database engine, and frees the connection data structure.
// This procedure closes the error handler and
// then closes the specified connection.proc logoff
DBMS CLOSE CONNECTION c1