Progress
DataServer
for ODBC Guide


Defining the ROWID

When you create or update a schema holder, the DataServer uses the following guidelines to select a column in an ODBC data-source table to support the ROWID function:

If more than one index in the data-source table meets the second level—unique, single-component, integer—the DataServer selects the first such index that it encounters to support the ROWID function. Note that the indexes in this class are not mandatory, hence it is essential that you enforce the column supporting ROWID as mandatory at least through code if not through definitions. If your application handles an index in such a way as to make it a better support for the ROWID function, you can designate it in the Progress Data Dictionary.

NOTE: An index that you select as a ROWID must be defined as a unique index. It must also be mandatory, if not by definition, then by means of the application code.

To select an index to support the ROWID function, follow these steps in the Data Dictionary with the schema holder connected (you do not have to connect to the ODBC data source):

  1. Choose the Tables mode button.
  2. Select the table whose ROWID you want to modify.
  3. Choose the Table Properties button.
  4. Choose the DataServer button. The following dialog box appears:
  5. Double-click an index to see detailed information on its attributes. The following dialog box appears:
  6. Choose OK to return to the ROWID Choices dialog box.
  7. Select the index that you want to use to support ROWID.
  8. Choose OK to return to the Table Properties dialog box.

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