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:
- Add a column of the same data type before the indexed column. The new column must immediately precede the indexed column.
- Name the column _S#_column1.
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.
- Set the _S#_ column to the uppercase value of the original column.
- Re-create the index with the _S#_ column as a component in place of the original column.
- 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 |