Setting the Database Dialect

From InterBase
Jump to: navigation, search

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.

Advance To: