CONNECT

Core command OPEN CONN CON

Opens a connection to a database

Arguments

a valid connection ID (mandatory)

Examples

CONNECT db01;

Notes

Opens a connection to a database: CONNECT <id>.

id is mandatory and must be a connection defined in the Connections Definition File (CDF) - the command fails otherwise. The connection is tested first; if the test fails, the command reports the failure and the current connection is left untouched.

On success, any currently open connection is closed automatically before the new one is opened, and the prompt changes to reflect the new connection. Unless connecting to the CDF itself, the session is added to the query log file if logging is enabled by default. SHOW DBINFO and SHOW AUTOCOMMIT are run automatically afterwards to summarize the new connection.

Last modified in release 5.0.7.