1.1.1

Example
sqlf version 10.4
sqlf> connect client 'localhost:1527' as clientConnection;
sqlf> show connections;
CLIENTCONNECTION* - jdbc:sqlfire://localhost:1527/
* = current connection
connect peer
Using the JDBC SQLFire peer client driver, connects to a SQLFire member with specified boot and connection
property values.
Syntax
CONNECT Peer 'property=value*' [ AS connectionName ]
Description
Using the JDBC SQLFire peer client driver, connects to a SQLFire member with specified boot and connection
property values. Optionally, specify a name for your connection. Use the set connection on page 457 to switch
between multiple connections. If you do not name a connection, the system generates a name automatically.
If the connection requires a user name and password, supply those with the optional properties.
If the connect succeeds, the connection becomes the current one and sqlf displays a new prompt for the next
command to be entered. If you have more than one open connection, the name of the connection appears in the
prompt.
All further commands are processed against the new, current connection.
Example
sqlf> connect peer 'mcast-port=12333;hosts-data=false' as
peerClient;
sqlf(PEERCLIENT)> show connections;
CLIENTCONNECTION - jdbc:sqlfire://localhost:1527/
PEERCLIENT* - jdbc:sqlfire:
* = current connection
sqlf(PEERCLIENT)>
describe
Provides a description of the specified table or view.
Syntax
DESCRIBE { table-Name | view-Name }
Description
Provides a description of the specified table or view. For a list of tables in the current schema, use the Show
Tables command. For a list of views in the current schema, use the Show Views command. For a list of available
schemas, use the Show Schemas command.
441
sqlf Interactive Commands