skip to main content
OpenAccess SDK SQL Engine core methods for Java : Exchanging data : dam_getTableSearchExp
 

dam_getTableSearchExp

This method returns the search condition (filter condition) and join conditions for the given table. This method is called from ipExecute by the IP to get the filter conditions and join conditions for each table in the join query.
int dam_getTableSearchExp(
    long   hstmt,
    int    iTableNum,
    long   phSearchExp,
    xo_int piJoinType,
    xo_int phJoinExp
    xo_int pbPartial)
Table 218. Parameters for dam_getTableSearchExp
Parameter
Type
Description
INPUT
hstmt
long
The statement handle.
iTableNum
int
The number of the table about which to get the conditions. Numbers start at 0.
OUTPUT
phSearchExp
long
The handle to the search expression that contains all the filter conditions applicable for the table. Use damex_describeLogicExp to get details of the logical search expression.
piJoinType
xo_int
Type of the Join:
SQL_JOIN_LEFT_OUTER - left outer join
SQL_JOIN_RIGHT_OUTER - right outer join
SQL_JOIN_FULL_OUTER - full outer join
SQL_JOIN_INNER - inner join
SQL_JOIN_OLD_STYLE - join condition specified in the WHERE clause. Implies inner join.
phJoinExp
xo_int
The handle to the search expression that contains all the join conditions for the table. Use damex_describeLogicExp to get details of the logical search expression.
pbPartial
xo_int
TRUE - Indicates that the complete expressions in the WHERE clause and JOIN condition are returned
FALSE - Indicates that expressions containing correlated sub-queries were not included in the returned search expression.
RETURN
int
DAM_SUCCESS - found table with matching iTableNum
DAM_NOT_AVAILABLE - invalid iTableNum. Matching table not found.
DAM_FAILURE - Requested iTableNum > 0 and query is not a join.