Set Connection command

The Set Connection command specifies which connection to make current when more than one connection is 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.

Syntax

SET CONNECTION Identifier

Example

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