Input File Format

For configuring eligible table columns, the Case Insensitivity Wizard can accept a comma-delimited .csv file as input. Each line in the file is one record that defines one column to be configured for CIAI queries.

The record format is as follows:

Table_Name,Column_Name,Method,Index_Strategy,Operation

The fields in the record are explained in the following example of a record:

S_CONTACT,EMAIL_ADDR,Database,Copy All,On

Only the first two items in the record are mandatory (Table_Name and Column_Name). For records where items are omitted, the Case Insensitivity Wizard inserts the default value for the items.

If you omit an item from a record, then you must still provide the item’s delimiting commas. Here is a record with the index strategy item omitted:

S_CONTACT,EMAIL_ADDR,Database,,On

The Case Insensitivity Wizard does not provide special handling for denormalized columns. To configure CIAI queries on denormalized columns, you must include them in an input file.

Oracle provides a recommended input file for Siebel Business Applications and for Siebel Industry Applications. The input files have a .csv extension and are located in the following directory:

Windows: $SIEBEL_HOME\objects