ij Commands and Errors Reference
Page 32 of 39

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.

Example

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