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 -
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.