Syntax for the derbyrun.jar file

The derbyrun.jar file is a special JAR file that simplifies how you invoke the Derby tools and the Network Server.

With the derbyrun.jar file, you can run the Derby tools and utilities using shortened names and you do not need to set the java CLASSAPATH environment variable. The derbyrun.jar file must be in the same folder as the other Derby JAR files.

Syntax

The syntax for using derbyrun.jar for each of the Derby tools is as follows:

Operating System	Command
UNIX (Korn Shell)	java -jar $DERBY_HOME/lib/derbyrun.jar ij [-p propertiesfile] [sql_script] java -jar $DERBY_HOME/lib/derbyrun.jar sysinfo [-cp ...] [-cp help] java -jar $DERBY_HOME/lib/derbyrun.jar dblook [arg]* (or no arguments for usage) java -jar $DERBY_HOME/lib/derbyrun.jar server [arg]* (or no arguments for usage)
Windows	java -jar %DERBY_HOME%\lib\derbyrun.jar ij [-p propertiesfile] [sql_script] java -jar %DERBY_HOME%\lib\derbyrun.jar sysinfo [-cp ...] [-cp help] java -jar %DERBY_HOME%\lib\derbyrun.jar dblook [arg]* (or no arguments for usage) java -jar %DERBY_HOME%\lib\derbyrun.jar server [arg]* (or no arguments for usage)

Operating System

Command

UNIX (Korn Shell)

java -jar $DERBY_HOME/lib/derbyrun.jar ij [-p propertiesfile] [sql_script] 
java -jar $DERBY_HOME/lib/derbyrun.jar sysinfo [-cp ...] [-cp help]

java -jar $DERBY_HOME/lib/derbyrun.jar dblook [arg]* (or no arguments for usage) 
java -jar $DERBY_HOME/lib/derbyrun.jar server [arg]* (or no arguments for usage)

Windows

java -jar %DERBY_HOME%\lib\derbyrun.jar ij [-p propertiesfile] [sql_script] 
java -jar %DERBY_HOME%\lib\derbyrun.jar sysinfo [-cp ...] [-cp help] 
java -jar %DERBY_HOME%\lib\derbyrun.jar dblook [arg]* (or no arguments for usage) 
java -jar %DERBY_HOME%\lib\derbyrun.jar server [arg]* (or no arguments for usage)

To see this syntax reminder, run the command java -jar derbyrun.jar with no arguments.

Additional information

The server argument is a shortcut for running the NetworkServerControl tool. For details on using this tool, see the Derby Server and Administration Guide.

For more information on using derbyrun.jar to run the ij, sysinfo, and dblook tools, see the Derby Tools and Utilities Guide.