Running ij

You can use the ij tool to connect to a Derby database.

• To start the ij tool, run the ij script from the command line. For example:

  ij

  The ij script starts the ij tool and sets up the environment variables like CLASSPATH.
• To create a database with the ij tool, type the following command:

  ij> connect 'jdbc:derby:testdb;create=true';

  This command creates a database called testdb in the current directory, populates the system tables, and connects to the database. You can then run any SQL statements from the ij command line.
• When you are ready to leave the ij tool, type:

  ij> exit;