Interactive SQL connections

The Interactive SQL (dbisql) utility has a different behavior from the default Embedded SQL behavior when a CONNECT statement is issued while already connected to a database. If no database or server is specified in the CONNECT statement, Interactive SQL connects to the current database, rather than to the default database. This behavior is required for database restarting operations.

For an example, see CONNECT statement [ESQL] [DBISQL] in Reference: Statements and Options.