Overview of What the Case Insensitivity Wizard Does

The Case Insensitivity Wizard performs the following functions in the repository to configure columns to support CIAI queries. No columns or indexes are created in the Siebel database until you synchronize the repository to the Siebel database. The columns you want to configure for CIAI queries are called base columns:

• Validates the syntax of all records if an input file is used.

• Validates that all specified tables and columns are eligible for CIAI configuration.

• For each eligible base column, defines a new CIAI column. The CIAI column contains the data in the base column converted to uppercase.

• If you select the Single or Copy All index strategy, then the wizard defines an index on the CIAI column.

• If you select the Copy All index strategy, then it defines a copy of all indexes that have the base column as a key. The new indexes reference the CIAI column instead of the base column.

• Sets the Default Insensitivity property for the base column to DB Case & Accent.

• Sets flags and performs other configuration operations in the repository to support CIAI queries.

The Case Insensitivity Wizard can also be run in a special mode to set the Default Insensitivity property on columns that do not have any indexes defined.

The main purpose of the CIAI query enhancements is to provide indexes that can be used for case insensitive searches. The database does not have to perform table scans to locate records. This allows the database to perform case insensitive searches more quickly.

For example, in S_CONTACT, you configure the column LAST_NAME for CIAI queries. The Case Insensitivity Wizard defines a column called LAST_NAME_CI. When you query for the name Smith, the Object Manager creates a query similar to the following (IBM DB2):

SELECT column list FROM S_CONTACT
WHERE LAST_NAME_CI = SMITH