Siebel Database Upgrade Guide > Siebel Case Insensitivity Wizard >

Overview of What the CIAI Wizard Does

Environments: Development environment only.

Platforms: Windows, UNIX, IBM z/OS.

Databases: All databases.

The CIAI 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, the wizard 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 CIAI 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 enhancement 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 CIAI 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 indicates SMITH

The database then uses the CIAI index on LAST_NAME_CI to locate the records.

For columns where Force Case is set, the data in the database is all in the same case. No CIAI columns or indexes are needed. The Object Manager uses the indexes already defined on the base column to retrieve records.