2.29 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 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