1. Database Upgrade Guide
  2. Eligibility Criteria

Eligibility Criteria

The Case Insensitivity Wizard verifies that all records in an input file or in columns that you manually select meet the following eligibility criteria:

  • The table and column must exist in the repository.

  • The column must be active and belong to the specified table.

  • The table type must be supported for CIAI configuration.

  • The column functional type must be supported for CIAI configuration.

  • The column physical type must be supported for CIAI configuration.

  • The column must have one or more indexes already defined on it. If no indexes are defined on the column, but the column is otherwise eligible, then the wizard accepts the column, but it does not create a CIAI column or any CIAI indexes for the column. The Case Insensitivity Wizard sets the Default Insensitivity to DB Case & Accent.