Product Documentation

SQL StatementsSET CONNECTION

SQL Reference Guide

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

TOCIndex