Setting the gpre Dialect
From InterBase
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 setsgpre
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:
Dialect explicitly specified within the source, for example EXEC SQL SET SQL DIALECT n |