Applications Administration Guide > Ongoing Application Administration Tasks >

Enabling Application-Wide Case Insensitivity

About the CaseInsensitive Parameter

Application-wide case sensitivity is controlled through the CaseInsensitive parameter of the named subsystem representing the data source definition.

The CaseInsensitive parameter only affects which data is retrieved by queries. It does not affect the order in which data appears on the screen. The sort sequence is database-dependent, and independent of the CaseInsensitive parameter.

In addition, the content of SRF files is case-sensitive in most cases and is not affected by how this parameter is set in the application configuration file.

You change the CaseInsensitive parameter in different ways, depending on whether you are working with Siebel Web Client or Siebel Dedicated Web Client:

• Enabling Application-Wide Case Insensitivity for Siebel Web Client
• Enabling Application-Wide Case Insensitivity for Siebel Dedicated Web Client

About the InsensitivityFactor Parameter

When you change the CaseInsensitive parameter, you may also want to change the InsensitivityFactor parameter to minimize performance degradation.

The default setting for the InsensitivityFactor parameter is 2.

NOTE:  Do not change the default value of InsensitivityFactor for Gateway Data Source (GatewayDataSrc) in the CFG file.

You may want to test a number of values for this parameter with your database, spool the SQL to see the effect of different settings on response time and then choose a value that meets your needs. For more information about the InsensitivityFactor parameter, see Siebel System Administration Guide.

Enabling Application-Wide Case Insensitivity for Siebel Web Client

For Siebel Web Client, you make changes to the CaseInsensitive parameter in the Administration - Server Configuration screen.

To enable application-wide case insensitivity for Siebel Web Client

1. Navigate to the Administration - Server Configuration screen > Enterprises view.
2. Click the Profile Configuration view tab.
3. In the Profile Configuration list, select a data source record, for example, the Server Datasource.
4. In the Profile Parameters list, change the value of the DSCaseInsensitiveFlg to True.

   Optionally, change the DSInsensitivityFactor parameter as well, to control performance degradation.

5. Stop and restart the Application Object Manager (AOM) server components.

Enabling Application-Wide Case Insensitivity for Siebel Dedicated Web Client

For Siebel Dedicated Web Client, application-wide case sensitivity is controlled through the CaseInsensitive parameter in the configuration file for your application.

The configuration file for each Siebel application has a section for each one of the potential data sources for the application. By default, each of these data source sections has the following line:

CaseInsensitive = FALSE

To enable application-wide case insensitivity for Siebel Dedicated Web Client

1. Use any text editor to open your application configuration (CFG) file.
2. Change the CaseInsensitive parameter to

   CaseInsensitive = TRUE

3. Optionally, change the InsensitivityFactor parameter to control performance degradation.

   The InsensitivityFactor parameter follows the CaseInsensitive parameter in each application configuration file.