Run dbbook
Getting Started with Derby
18
Method
When to Use
Command
Java programming
language.
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
.
Then specify the class name in the
java
command. For example:
java 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.
Running dblook
The Derby
dblook
utility is a Data Definition Language (DDL) generation utility.
The
dblook
utility is a simple utility that dumps all or parts of the DDL of a user-specified
database to either a console or a file. The generated DDL can then be used for such
things as recreating all or parts of a database, viewing a subset of the objects in a
database (for example, those objects that pertain to specific tables and schemas), or
documenting the schema of a database.
Choose the method that you will use to run the
dblook
script. The methods are listed in
the following table.
Table 7.
Methods of running the
dblook
utility
Method
When to Use
Command
Run
dblook
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
before you run the
dblook
utility using this method.
To run the
dblook
script from the
command line use:
dblook -d connectionURL [options]
The
dblook
script sets the appropriate
environment variables, including the
CLASSPATH, and runs the
dblook
utility.
