Progress
DataServer
for ORACLE Guide


Defining the ROWID

When you create or update a schema image, the DataServer uses the following guidelines when determining how to support the ROWID function:

The Progress Data Dictionary allows you to select the native ROWID or an alternative index to support the ROWID function. The alternative index should be a stable one.

NOTE: If you are connected to an ORACLE database and you change how the ROWID is supported for a table, you must reconnect to the database to avoid inconsistent row identifiers.

An index that you select must be defined to meet at least these criteria:

Your application must address these additional criteria if the index definition does not meet them:

For example, your application might access an indexed column defined as a NUMBER column, but the scale might not be specified. If your application assigns only values between 1 and 214783647 to this column, it meets one of the additional criteria. Your application must ensure that the indexed column meets the other two criteria as well. If you do not meet all three criteria, you risk corrupting your database.

To select an index to support the Progress ROWID function, follow these steps in the Data Dictionary:

  1. Select the table from the Tables list.
  2. Choose the Table Properties button.
  3. Choose the DataServer button. The ROWID Choices dialog box appears:
  4. Choose native ROWID or an index to support the ROWID function. If the ORACLE table contains a PROGRESS_RECID column, the following message appears:
  5. Choose OK to return to the Table Properties dialog box.
  6. Choose OK to return to the Data Dictionary.
  7. If you referenced the table during the current session, you must disconnect from ORACLE, then reconnect, for the ROWID selection to take effect.

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