# Running ij

The Derby `ij` tool is a JDBC tool that you can use to run scripts or interactive queries against a Derby database.

- Choose the method that you will use to run the `ij` script. The methods are listed in the following table.

  Table 1. Methods of running the `ij` utility
  Method | When to Use | Command
  --- | --- | ---
  Run `ij` as a standalone command. | Use this method if you are relatively new to the Java programming language and new to Derby. | Follow the steps in Setting the environment variables before you run the `ij` tool using this method. To run the `ij` script from the command line, use:
      ij
  You must add the `DERBY_HOME/bin` directory to your PATH environment variable before you can run the `ij` tool. The `ij` script sets the appropriate environment variables, including the CLASSPATH, and starts the `ij` tool.
  Run `ij` using the jar file that is located in the directory where `ij` resides. | Use this method if you are new to Derby, but are familiar with the Java programming language. | You must set the DERBY_HOME environment variable before you can run the `ij` tool using this method. On UNIX, the command is:
      java -jar $DERBY_HOME/lib/derbyrun.jar ij
  On Windows, the command is:
      java -jar %DERBY_HOME%\lib\derbyrun.jar ij
  Run `ij` using the `java` command. | Use this method if you are familiar with both the Java programming language and Derby, and you have already added the location of the `java` executable file to your command execution PATH. | You must set your CLASSPATH. Use the steps specified in Manually setting the CLASSPATH/MODULEPATH environment variables. Then specify the class name in the `java` command. For example:
      java org.apache.derby.tools.ij
  Run `ij` using the `java` command with a modulepath. | Use this method if you are familiar with both the Java programming language and Derby, have already added the location of the `java` executable file to your command execution PATH, and expect to run Derby via the modulepath. | You must set your MODULEPATH. Use the steps specified in Manually setting the CLASSPATH/MODULEPATH environment variables. Then specify the tools module and the ij class name in the `java` command. On UNIX, the command is:
      java -p $MODULEPATH \
        -m org.apache.derby.tools/org.apache.derby.tools.ij
  On Windows, the command is:
      java -p %MODULEPAT% ^
        -m org.apache.derby.tools/org.apache.derby.tools.ij

- When you are ready to leave the `ij` tool, type:

      ij> exit;

See the Derby Tools and Utilities Guide for more information about the `ij` tool.
Parent topic: Using the Derby tools and startup utilities