DataDirect OpenAccess SDK Help

dam_getTableSearchExp

Save PDF

dam_getTableSearchExp

Save PDF

Last Updated: May 12, 2026
1 minute read

OpenAccess SDK
Version 8.1
Documentation

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)

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.