Set Connection

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.

Examples

ij> protocol 'jdbc:derby:';
ij> connect 'toursDB' as tours1;
ij> connect 'newDB;create=true' as newDB;
ij (NEWDB)> show connections;
TOURS1 -    jdbc:derby:toursDB
NEWDB* -    jdbc:derby:newDB;create=true
* = current connection
ij(NEWDB)> set connection tours1;
ij(TOURS1)> disconnect all;
ij>