SET CONNECTION Identifier
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.
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>