Configuring CIAI Support for Columns That Do Not Have Indexes Defined
If a column does not have any indexes defined, then the Case Insensitivity Wizard does not create new columns or indexes.
However, you can run the wizard in special mode that changes the column’s Default Insensitivity property to DB Case & Accent. The Wizard performs these steps on all eligible columns in the repository. You cannot manually select columns.
Requirements: Review About the Siebel Case Insensitivity Wizard for information on how the Case Insensitivity Wizard works, eligibility criteria, and how to edit input files.
To configure columns without indexes
In Siebel Tools, open the repository.
From the Tools menu, choose Utilities, then Case Insensitivity.
The Case Insensitivity Wizard displays.
Select Enable for all unindexed columns.
Click Next.
The Wizard locates unindexed columns that meet CIAI eligibility criteria. The Wizard then displays a list of tables that must be locked.
Click Export to export the list of tables to a text file. Then exit the wizard.
Lock all the tables in the text file.
Start the Case Insensitivity Wizard again, and select Enable for all unindexed columns.
The Wizard locates unindexed columns and then displays a page listing how they will be configured.
Verify that for all the columns that the method is set to Database, and Index Strategy is set to None.
When the index strategy is set to None, the wizard does not create a CIAI column or indexes.
When you click Next, the wizard displays a page listing the repository changes it will make.
Verify that for all columns, Default Insensitivity will be changed to DB Case & Accent. Click Finish.
The Wizard makes the changes to the repository.