Kbase P106438: Selecting an index to support the rowid function with the ODBC dataserver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/11/2009 |
|
Status: Verified
GOAL:
How to select an index to support the ROWID function in an ODBC data source.
FACT(s) (Environment):
Windows
ODBC DataServer
FIX:
To allocate an index for ROWID support, certain criteria must be met, please follow the guidelines in the documentation.
Once you have met the criteria, connect to the scheme holder and your foreign data source, go to the Data Dictionary.
Here you have two methods available:
Method 1:
1. Select the table for which you want to allocate the ROWID support.
2. Choose the table properties button.
3. Choose the DataServer button.
4. Select the index from the ROWID Choices dialog and press OK.
Method 2 (OpenEdge Only):
1. Select the table for which you want to allocate the ROWID support.
2. Select the index view and go to the index properties of the index you want to allocate the ROWID support.
3. Check the ROWID toggle-box to activate your selection and press OK.