Method Variable of the Case Insensitivity Wizard

The method variable of the Case Insensitivity Wizard determines how the wizard configures a CIAI query for a column. This topic describes the methods that are available.

About the Force Case Method

If you set the method to Force Case, then the Case Insensitivity Wizard does not create a CIAI column or index. You can use the Force Case method for a column where the Force Case property of a table column is already set.

If the Force Case property is FirstUpper, Lower, or Upper, then Siebel CRM forces the column data to the case that is set in the Force Case property before it writes data to the Siebel database. All data in the base column is in the same case. The object manager can use the base column and the base column indexes for a query that is not case-sensitive. A CIAI column and CIAI indexes are not required. To get records, the object manager uses the indexes that Siebel CRM already defines on the base column.

If Force Case is FirstUpper, LOWER, or Upper, then the Case Insensitivity Wizard considers Force Case to be set for a column. If Force Case is empty, then the wizard does not consider Force Case to be set.

About the Database Method

The Database method defines a CIAI column for the base column. It uses the index strategy variable to create indexes. The Case Insensitivity Wizard does the following work for indexes that contain multiple columns as keys:

• For the first key where the column becomes CIAI enabled, the wizard defines a copy of the index. In the copy, the key references the CIAI column instead of the base column.

• For each additional key that is CIAI enabled, the wizard deletes the index copy in the Siebel repository and redefines it so keys reference the additional CIAI columns.

For example, assume the following:

1. The S_CONTACT table contains Base Column A. This column includes Index A, which uses the LAST_NAME and FST_NAME columns as keys.

2. You choose the LAST_NAME column for a CIAI query and define the Copy All index strategy.

3. The Case Insensitivity Wizard defines the LAST_NAME_CI column and a CIAI index for the new column.

4. To create Index B for Base Column A, the wizard copies Index A and specifies LAST_NAME_CI and FST_NAME as keys.

5. You choose the FST_NAME column for a CIAI query.

6. As part of configuring FST_NAME for a CIAI query, the wizard does the following work in the Siebel repository:

   • Defines a new FST_NAME_CI column.

   • Deletes Index B on Base Column A and redefines it with the LAST_NAME_CI and FST_NAME_CI keys.

For more information, see Index Strategy Variable of the Case Insensitivity Wizard.