Setting the Database Dialect

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.