How the Case Insensitivity Wizard Applies a Naming Format

When the Case Insensitivity Wizard creates a CIAI column name or index name, it uses a naming format that is similar to the naming format that the EIM Table Mapping Wizard uses. The naming format is fixed. You cannot override it. For more information, see Mapping a Custom Table to an Interface Table and Objects You Use with Enterprise Integration Manager.

The Case Insensitivity Wizard uses the following naming format:

• Column name. Appends a _CI suffix to the CIAI column name. For example, if the parent column is LAST_NAME, then the CIAI column is LAST_NAME_CI.

• Index name. Uses the following format to append a string to the base table name:

  BASE_TABLE_NAME_C#

  where:

  • # is an integer starting at 1 and incremented as required to create a unique name.

  For example, S_CON_ADDR_C1 is a CIAI index that the wizard creates for the S_CON_ADDR table.