1.1.1

Any changes made to the sqlf environment by the file are visible in the environment when processing resumes.
Example
sqlf(PEERCLIENT)> run 'ToursDB_schema.sql';
set connection
Specifies which connection to make current when more than one connection is open.
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 on page 457 command to display open connections.
If there is no such connection, an error results and the current connection is unchanged.
Example
sqlf(PEERCLIENT)> set connection clientConnection;
sqlf(CLIENTCONNECTION)> show connections;
CLIENTCONNECTION* - jdbc:sqlfire://localhost:1527/
PEERCLIENT - jdbc:sqlfire:
* = current connection
sqlf(CLIENTCONNECTION)>
show
Displays information about active connections and database objects.
Syntax
SHOW
{
CONNECTIONS |
IMPORTEDKEYS [ IN schemaName | FROM table-Name ] |
INDEXES [ IN schemaName | FROM table-Name ] |
PROCEDURES [ IN schemaName ] |
SCHEMAS |
SYNONYMS [ IN schemaName ] |
TABLES [ IN schemaName ] |
VIEWS [ IN schemaName ] |
}
Description
Displays information about active connections and database objects.
457
sqlf Interactive Commands