For backward compatibility, the DataServer supports the RECID function for ODBC data source tables that have a unique four-byte integer column defined as the key for the ROWID/RECID index of a given table in the schema holder. Whenever the ROWID index selection for a schema holder table in the Dictionary has a multi-component key composite or is a single-component key but not a single unique integer component, the RECID function is not supported and the compiler will disallow the use of the RECID function in a WHERE clause.
Note: The ROWID function does not have this same restriction and is the recommended alternative for this limitation.
You can make an existing application that includes RECID behave more consistently across data sources by replacing RECID with ROWID. For more information, see ROWID function.
