Programming Guide

CLOSE CONNECTION

Closes a declared connection

Synopsis

DBMS CLOSE CONNECTION [connection]

Arguments

connection
Name of connection to be closed. If connection name is not included, the default connection is closed.

Description

Executing DBMS CLOSE CONNECTION closes all open cursors associated with the named or default connection, logs off the connection from its database engine, and frees the connection data structure.

Example

// This procedure unsets the error handler and
// then closes the specified connection.
 
proc logoff
DBMS ONERROR
DBMS CLOSE CONNECTION c1
return

See Also

CLOSE_ALL_CONNECTIONS, dm_is_connection