1. Database Upgrade Guide
  2. Operation: Inactivating CIAI Configuration

Operation: Inactivating CIAI Configuration

The Operation field in the configuration syntax controls whether the columns and indexes created by the Case Insensitivity Wizard are active. The available settings are On and Off. The default is On.

Use the Operation field to deactivate the CIAI configuration of columns. When you run the Case Insensitivity Wizard against a column and specify Operation indicates Off, the wizard does the following:

  • Inactivates the CIAI column created on the base column.

  • Inactivates the CIAI index created for the CIAI column.

  • For indexes that the base column participates in, sets the related CIAI indexes to inactive.

Note that the Case Insensitivity Wizard does not delete CIAI columns or CIAI indexes in the repository.

You cannot use Operation indicates Off to set the Default Insensitivity property on a column from DB Case & Accent to None.