How to Configure SQL Command

Previous Next

See Also

Within your SQL scripts you can type in the following commands to configure the output of your scripts, as well as the way they are processed.



SET autoCommit True|False

If set to True, a commit will be requested after every record manipulated. Default: False.

SET commentBegin <string>

The string is interpreted as the start of a comment. The comment runs on until a "commentEnd" string is encountered.

Default: /*

SET commentEnd <string>

This string is interpreted as the end of a comment. Default: */

SET echoComment True|False

If set to true, comments will be echoed to the screen. Default: True.

SET echoStatement True|False

If set to True, statements will be echoed to the screen before they are executed Default: False.

SET gutter <integer>

Specifies the number of spaces between output columns. Default: 2

SET noSqlInMessages True|False

If set to True, the messages fired as a result of the script do not contain SQL statement text. Additional messages that only contain the erroneous SQL statement are not displayed at all.

If set in a script, the setting only applies to the commands in that script.

You can also use the resource setting "*Script*noSqlInMessages: True"

This applies to all scripts (unless overruled within a script).

Default: False.

SET outputEncoding ANSI|UTF8

If the output goes to a file this option specifies the encoding of the output file.

Possible values are ANSI and UTF8. Use "SET outputEncoding" before "SET

reportFile" in a script.

SET quitOnError True|False

If set to True, processing will stop as soon as an error is encountered. Default: True.

SET quitzeroRows True|False

If set to True, processing will stop if a SELECT statement does not retrieve any records. Default: True.

SET reportFile <filename>

Sends the output to the file specified. This is particularly useful if the output is more than 32 Kb (which is the maximum that the SQL Command window can display).

SET rollbackOnError True|False

If set to True, a rollback is performed when an error occurs. Default: False.

SET separator <string>

Specifies the value interpreted as separator between SQL statements. Default: ; (semi-colon).

SET showErrorMessages True|False

If set to True, and showMessages is set to False, then only messages for real errors such as constraint violations are shown. Default: False.

SET showMessages True|False

If set to True, messages generated while executing the script will be displayed on the screen. Default: False.