skip to main content
IP API Reference for Java : Statement-level Methods for Java : sqlipBestRowIdentifier
 

sqlipBestRowIdentifier

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);
 
Table 78: 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