ROWID characteristics
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
ROWID characteristics
If you migrated your database to Oracle and
elected to use the CREATE RECID FIELD option during
the migration, a unique 8-byte Integer column named PROGRESS_RECID will
have been automatically generated in your database tables along
with a corresponding Index containing the PROGRESS_RECID value
as its key.
Databases that are only pulled from the native
environment or are migrated without the CREATE RECID FIELD option
must either choose a unique index key from each table or the native ROWID to
represent the PROGRESS_RECID to support the RECID and ROWID functions,
and forward and backward scrolling within their ABL sessions. OpenEdge will
internally map the selected unique key or native ROWID to
the PROGRESS_RECID and ROWID functions.
It is important to note that the unique index key used to derive
the OpenEdge ROWID must be a single component
index for it to map to the ROWID of a temp-table
as described in the following discussion. For more details, see
the ROWID function discussion in Initial Programming Considerations.
Also, before discussing ROWID as
it relates to the RUN STORED-PROC statement, it
is important to understand an important property of the OpenEdge ROWID.
See ROWID: Standard ABL behavior for more information.