Set ConnectionSet ConnectionConnectionswitchingSyntaxSET CONNECTION IdentifierDescription
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.
Exampleij> 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>