set connection

Specifies which connection to make current when more than one connection is open.

Syntax

SET CONNECTION Identifier

Description

Allows you to specify which connection to make current when you have more than one connection open. Use the Show Connections command to display open connections.

If there is no such connection, an error results and the current connection is unchanged.

Example

sqlf(PEERCLIENT)> set connection clientConnection;
sqlf(CLIENTCONNECTION)> show connections;
CLIENTCONNECTION* -     jdbc:sqlfire://localhost:1527/
PEERCLIENT -    jdbc:sqlfire:
* = current connection
sqlf(CLIENTCONNECTION)>