Chapter 3 DBMS Reference Guide
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:
|
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |