Using ij commands

The primary purpose of ij is to allow the execution of Derby SQL statements interactively or via scripts. Since SQL statements can be quite long, ij uses the semicolon to mark the end of a statement or command. All statements and commands must be terminated with a semicolon. If you press Return before terminating a statement or command, ij places a continuation character (>) at the beginning of the next line.

ij uses properties, listed in ij properties reference, to simplify its use.

ij also recognizes specialized commands that provide additional features, such as the ability to create and test cursors and prepared statements, transaction control, and more. For complete information about ij commands, see ij commands and errors reference.