SET SQL DIALECT
Go Up to Statement and Function Reference (Language Reference Guide)
Declares the SQL Dialect for database access. Available in gpre and isql.
SET SQL DIALECT n;
| Argument | Description |
|---|---|
|
<n> |
The SQL Dialect type, either 1, 2, or 3 |
Description: SET SQL DIALECT declares the SQL Dialect for database access.
n is the SQL Dialect type 1, 2, or 3. If no dialect is specified, the default dialect is set to that of the specified compile-time database. If the default dialect is different than the one specified by the user, a warning is generated and the default dialect is set to the user-specified value.
| SQL Dialect | Used for |
|---|---|
|
1 |
InterBase 5 and earlier compatibility. |
|
2 |
Transitional dialect used to flag changes when migrating from dialect 1 to dialect 3. |
|
3 |
Current InterBase; allows you to use delimited identifiers, exact numerics, and |
Examples: The following embedded SQL statement sets the SQL Dialect to 3:
EXEC SQL
SET SQL DIALECT 3;