Setting the gpre Dialect

Go Up to Setting SQL Dialects

In InterBase 6 and later, default behavior of gpre is to take on the dialect of the database to which it is connected. This enables gpre to parse pre-Version 6 source files without moderation.

There are two ways to change the dialect of gpre:

• Start gpre with option -sql_dialect n. For example, this command sets gpre to dialect 3:

gpre -sql_dialect 3

• Specify dialect within the source, for example:

EXEC SQL
SET SQL DIALECT n

The dialect precedence for gpre is as follows:

Lowest Middle Highest

Dialect of an attached database Command line specification: gpre -sql_dialect n Dialect explicitly specified within the source, for example EXEC SQL SET SQL DIALECT n

Advance To:

• Setting the Database Dialect