The Syntax category is located in the
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: |