sqlf implements a command-line tool that is based on the Apache Derby ij tool. You can use sqlf to connect to a SQLFire cluster and run scripts or interactive queries. You execute sqlf using the sqlf or sqlf.bat script.
cd quickstart
The quickstart directory contains example SQL script files that you will use later in the tutorial.
sqlf
This command starts the interactive shell and displays the prompt: sqlf>.
help;
connect client 'ip_address:1527';
Notice that SQLFire does not have the concept of a "database". When you connect to a SQLFire cluster, the distributed system that you connect to is defined by the locator (or alternately, the mcast-port) specified in the JDBC or ADO.NET connection.
show tables in sys;
You will use information from many of these tables to view information and statistics about a working SQLFire cluster.
select id from sys.members;
You will see output similar to:
ID ------------------------------- 0.0.1.11(41533)<v2>:52614/50508 localhost(41149)<v0>:32977/50114 10.0.1.11(41502)<v1>:49915/50462 3 rows selectedThe output displays the member process ID that is also logged when you start the members at the command line (41149, 41502, and 41533 in the tutorial example).