Define new columns to support a CIAI query.

Use an input file or choose files manually.

Deactivate CIAI for defined columns.

Use an input file that specifies the columns. For each column, set Operation to Off.

Modify the Default Insensitivity property from None to DB Case & Accent for eligible columns without indexes.

Choose the Tools menu, Utilities, and then the Case Insensitivity menu item. Choose the Enable for All Unindexed Columns option.

Modify the method from Force Case to Database for columns that are already defined.

Use an input file or choose files manually.

Modify the method from Database to Force Case for columns that are already defined.

Use an input file that specifies the columns. For each column, set Operation to Off. This configuration deactivates the CIAI column and CIAI indexes. Verify that the Force Case property is set for base columns.

Modify the index strategy from Single to Copy All for columns that are already defined.

Use an input file that specifies to modify the index strategy from Single to Copy All.

Modify the index strategy from Copy All to Single for columns that are already defined.

Do the following:

• Run the Case Insensitivity Wizard, using an input file that specifies the columns. For each column, set Operation to Off. This configuration deactivates the CIAI column and CIAI indexes.
• Next, run the Case Insensitivity Wizard on the same base columns with method set to Database and Index Strategy set to Single. This configuration activates the index on the CIAI columns.