CONNECT

Syntax

CONNECT <user>[/<password>][@<connection string>];

Description

Using this command, you can establish a new connection with Exasol.

If a connection already exists, this connection will be disconnected when a new connection is successfully established. If no password is specified, then you will be requested enter the password by EXAplus. If <connection string> is not specified, the information of the last connection is used. A COMMIT will also be performed if "SET AUTOCOMMIT EXIT" has been set.

Examples
CONN scott/tiger;
CONNECT scott/gondor@191.168.2.1:8563;