Installing and Executing DSQL

Download

Download here.

Installation

DSQL requires Java >=1.2 (1.4 if using Oracle driver). It is known to run under Linux, Darwin, Windows and cygwin.

If you plan to invoke DSQL from the command-line (especially for Linux/Darwin), add $DSQL_HOME/bin to your execution path, and set $DSQL_HOME to your installation directory.

Execution

There are several ways to invoke the DSQL interpreter:

• With the GUI. On Windows, open dsql.exe. On other systems, execute bin/dsql -i.

• Invoke the interpreter with a file. Type dsql filename.
• She-bang syntax (for Linux,Darwin,Cygwin). DSQL scripts can be executed directly, in the same manner as bash or Perl scripts. Copy dsqlexec, a system-dependent program found under $DSQL_HOME/bin/OS, to /usr/local/bin or a similar directory. Set the first line of the scripts to #!/usr/local/bin/dsqlexec.

Troubleshooting

• GUI does not start on Windows. Probably javaw cannot be found. Either add it to your execution path, or set an absolute reference in dsql.cfg.