Syntax Category

The Syntax category is located in the Root > Script > SQL category, and contains the following items that define the DBMS-specific syntax:

Item

Description

BlockComment

Specifies the character used to enclose a multi-line commentary.

Example:

/* */

Block Terminator

Specifies the end of block character, which is used to end expressions for triggers and stored procedures.

Delimiter

Specifies the field separation character.

Identifier Delimiter

Specifies the identifier delimiter character. When the beginning and end delimiters are different, they must be separated by a space character.

LineComment

Specifies the character used to enclose a single line commentary.

Example:

%%

Quote

Specifies the character used to enclose string values.

Note that the same quote must be used in the check parameter tab to enclose reserved words used as default.

SqlContinue

Specifies the continuation character. Some databases require a continuation character when a statement is longer than a single line. For the correct character, refer to your DBMS documentation. This character is attached to each line just prior to the linefeed.

Terminator

Specifies the end of statement character, which is used to terminate create table, view, index, or the open/close database, and other statements.

If empty, BlockTerminator is used instead.

UseBlockTerm

Specifies the use of BlockTerminator. The following settings are available:

  • Yes - BlockTerminator is always used

  • No - BlockTerminator is used for triggers and stored procedures only