skip to main content
OpenEdge Data Management: DataServer for ODBC
The DataServer Tutorial : Adding extended ABL support : Modifying tables to support case-insensitive indexes
 

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#_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.
3. Set the _S#_column to the uppercase value of the original column.
4. Recreate 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.