Previous Topic

Next Topic

SET CONNECTION

Description

SET CONNECTION sets the database associated with the connection name as the current database.

Syntax

SET CONNECTION connection_name ;
connection_name::
      { character_literal | host_variable | DEFAULT }

Notes

If DEFAULT is specified, there should exist a DEFAULT connection (this could have been previously achieved through a CONNECT TO DEFAULT statement). All c-treeACE SQL statements are executed for the current database.

Examples

  SET CONNECTION "salesdb";
  SET CONNECTION DEFAULT;

Authorization

None.

SQL Compliance

SQL-92

Environment

Embedded SQL and interactive

Related Statements

DISCONNECT, SET CONNECTION