The Sql Tool commands and settings are intuitive once you are familiar with the usage idioms.
This Guide does not attempt to list every Sql Tool command and option available.
How to do this is documented in the Accessing older HSQLDB Databases with Sql Tool section below.
This document explains how to use Sql Tool, the main purpose of which is to read your SQL text file or stdin, and execute the SQL commands therein against a JDBC database.
You can easily change this behavior to auto-commit, exit-upon-error, etc., for the current session or for all interactive invocations.
To clarify this last, if you have to do your SQL client work on a work server on the other side of a VPN connection, you will quickly appreciate the speed difference between text data transmission and graphical data transmission, even if using VNC or Remote Console.
Another case would be where you are doing some repetitive or very structured work where variables or language features would be useful.
For SQL script-writers, you will have access to portable scripting features which you've had to live without until now.
You can use variables set on the command line or in your script.
If you wish, you can detect and handle error (or other) conditions yourself.