Progress
DataServer
for ODBC Guide


Modifying Tables to Support Case-insensitive Indexes

To uses case-insensitive indexes with an ODBC data source, make the following changes to your data-source table:

  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#_column1.
  3. 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.

  4. Set the _S#_ column to the uppercase value of the original column.
  5. Re-create the index with the _S#_ column as a component in place of the original column.
  6. 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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095