You can run scripts in ij in any of the following ways:
You can save output in any of the following ways:
java -Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver org.apache.derby.tools.ij <myscript.sql> > <myoutput.txt>
java -Dij.outfile=<myoutput.txt> org.apache.derby.tools.ij <myscript.sql>
ij exits when you enter the Exit command or, if you give a command file on the Java invocation line, when the end of the command file is reached. When you use the Exit command, ij automatically shuts down an embedded Derby system by issuing a connect jdbc:derby:;shutdown=true request. It does not shut down Derby if it is running in a server framework.