SET SQL DIALECT

From InterBase
Jump to: navigation, search

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.

Set SQL Dialects for Database Access
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 DATE, TIME, and TIMESTAMP data types.

Examples: The following embedded SQL statement sets the SQL Dialect to 3:

EXEC SQL
SET SQL DIALECT 3;

See Also

Advance To: