Setting gpre Client Dialect
From InterBase
Go Up to Preprocessing
By default, gpre
takes on the dialect of the database to which it is connected. This enables gpre
to parse older source files without modification. You can set gpre
to operate as a client in a different dialect in these ways:
Start gpre
with option -sql_dialect
n, where n is 1, 2, or 3:
gpre -sql_dialect n
Specify dialect within the source, for example:
EXEC SQL SET SQL DIALECT n
gpre
dialect precedence is as follows:
- lowest - dialect of an attached database
- middle - dialect specified on the command line
- highest - dialect specified in the source