SET CONNECTION

Sets the current connection.

set_connection.png

 

 

Usage

Embedded/Interactive/Module.

Description

The specified connection becomes current. The connection must specify an existing connection name. If it does not, an error code is returned and the connection status remains unchanged.

connection is case-sensitive.

connection can be specified as a host variable or a literal.

Example

SET CONNECTION 'connection 2';

Standard Compliance

Standard

Compliance

Comments

SQL-2016

Features outside core

Feature F771, “Connection management”.