sqlipBestRowIdentifier
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
This method is called by the OpenAccess SDK layer to get an optimal set of columns that uniquely identifies a row in a table.
int sqlipBestRowIdentifier(
String catalog,
String schema,
String table,
int scope,
boolean nullable);
Parameters for sqlipBestRowIdentifier
| Parameter | Type | Description |
| INPUT | ||
| catalog | String | A string object representing a catalog name used to narrow the search. Null indicates that the catalog name should not be used to narrow the search. |
| schema | String | A string object representing a schema name used to narrow the search. Null indicates that the schema name should not be used to narrow the search. |
| table | String | A string object representing a table name used to narrow the search. Null indicates that the table name should not be used to narrow the search. |
| scope | int | Indicates scope of interest. Value will be one of the following: SQL_SCOPE_CURROW, SQL_SCOPE_TRANSACTION, SQL_SCOPE_SESSION. |
| nullable | Boolean | True to indicate that columns that are nullable may be included; false to exclude columns that can be null. |
| RETURN | ||
| int | OADS_SUCCESS OADS_ERROR |