Set Connection commandThe Set Connection command specifies which
connection to make current when more than one connection is open.Set Connection commandConnectionswitching
Use the
Show Connections
command to display open connections.
If there is no such connection, an error results and the current connection
is unchanged.
SyntaxSET CONNECTION IdentifierExampleij> 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>