Using ij commands

ij accepts a number of different commands that let you execute SQL statements or run scripts. Each ij statement must end with a semicolon.

For complete information about ij commands, see ij commands and errors reference.

ij is a JDBC-neutral scripting tool with a small command set. It can be used to access any JDBC driver and database accessible through that driver.

The main benefit of a tool such as ij is that it is easy to run scripts for creating a database schema and automating other repetitive database tasks.

In addition, ij accepts and processes SQL commands interactively for ad hoc database access.