Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

> ## RECID function

> For backward compatibility, the DataServer supports the `RECID` function for ODBC data-source tables that have a unique 4-byte integer column.

> When compatibility is switched on, the Progress-to-ODBC migration utility creates an indexed NUMBER column with unique values for each row called `PROGRESS_RECID`. You can also add this column to ODBC tables manually if you are using an existing native data source or if you ported an OpenEdge database without compatibility switched on. For instructions, see Appendix A "Upgrading DataServer Applications."

> The Data Dictionary automatically designates the column that meets the unique 4-byte integer criteria. You can modify an index in an ODBC data-source table to support `RECID`. For a complete description of the `RECID` function, see its reference entry in the OpenEdge Development: Progress 4GL Reference .

> You can make an existing application that includes `RECID` behave more consistently across data sources by replacing `RECID` with `ROWID`. See the "ROWID function" section for more information.

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