Running the Case Insensitivity Wizard by Selecting Columns

This procedure assumes the Object Explorer is in Types mode where objects are displayed hierarchically. An alternate way to perform the procedure is to display Object Explorer in Flat mode. Then choose the Column object and navigate to the desired 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.

Running the Case Insensitivity Wizard by selecting columns

In Siebel Tools, open the repository.
In the Siebel Tools Object Explorer, select Table.
In the Tables list, lock the desired table, and highlight it.
In the Object Explorer, select Table, then Column.
In the Columns list, select the desired columns.
Right-click the highlighted columns, and choose Case Insensitivity from the pop-up menu.
The Case Insensitivity Wizard validates the eligibility of the selected columns. The Wizard lists any columns that have eligibility errors. If you continue, then the wizard skips columns containing errors.
Export the error listing to a text file for reference, correct any errors, and restart the Case Insensitivity Wizard. Click Export to export the error listing.
The Wizard displays the configuration settings it will use to configure the columns.
Review the configuration settings and verify they are correct.
If you want to change any configuration settings, then click Export.
The Wizard exports the listing to a text file in input-file format. Edit the text file, then run the Case Insensitivity Wizard and specify the text file as the input file.
If the configuration settings are correct, then click Next.
The Wizard displays the changes it will make to the repository tables and indexes.
If you want to save a record of the changes, then click Export.
The Wizard writes the changes to a text file.
Click Finish.
The Wizard configures the columns in the repository to support CIAI queries.