Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

> ## Modifying tables to support case-insensitive indexes

> You can use case-insensitive indexes with an ODBC data source, after making certain changes to your data-source table.

> | To modify tables to support case-insensitive indexes:

> 1. Add a column of the same data type before the indexed column. The new column must immediately precede the indexed column.

> 2. Name the column `_S#_``column`1.

> For example, if your table has an indexed column named `emp_id`, name the new column `_S#_emp_id`. The new column accommodates the uppercase version of the index.

> 3. Set the `_S#_ column` to the uppercase value of the original column.

> 4. Re-create the index with the `_S#_ column` as a component in place of the original column.

> 5. If you have already created your schema holder, update it to reflect your changes to the data-source table.

> Note: For Informix case-insensitive indexes, provide "`_S__` (underscore followed by "S" followed by two "_") instead of "`_S#_`" (underscore followed by "S" followed by number sign followed by underscore).

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095