Setting the Database Dialect
From InterBase
Go Up to Setting SQL Dialects
To set the dialect of an ODS 10 or later database, attach to the database as either the owner or SYSDBA. Use gfix
with the command-line option -sql_dialect
n
, where n is 1 or 3. For example, the following statement sets mydb.ib
to dialect 3:
gfix -sql_dialect 3 mydb.ib
See Migrating Databases to Dialect 3 for details about issues to consider before you issue the command.