|
|
|
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 FairCom DB 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 |
