Adjusting the Case of Values

EIM supports various case values defined for base table columns in Siebel Tools. EIM adjusts the case value of an EIM table column according to the Force Case property of the corresponding base table column.

Note: The case values supported by EIM are listed in the Force Case property of the Column object in Siebel Tools. Force Case is a protected property that you cannot change.

Prior to importing data into base table columns, EIM also adjusts the case of values in EIM table columns as defined in the list of values. The available case modes include:

• Upper (Makes all letters uppercase)

• Lower (Makes all letters lowercase)

• FirstUpper (Makes the first letter of each word uppercase and leaves other letters unchanged)

• None (Has no effect)

Note: Letters are defined as A through Z (ASCII only). Words are defined as groups of letters separated by spaces (not punctuation).

If a requested case mode is not supported by the database, EIM performs a row-by-row pass through the EIM table to adjust the case of column values and update the row accordingly. If this occurs, you should expect slower import processing.

Note: To change the case mode requires changing read-only properties defined at the table level. For help contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services.