dam_getTableSearchExp
- 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(
int64 hstmt,
int iTableNum,
out int64 phSearchExp,
out int64 piJoinType,
out int phJoinExp)
Parameters for dam_getTableSearchExp
| Parameter | Type | Description |
| IN | ||
| hstmt | int64 | The statement handle |
| iTableNum | int | The number of the table about which we want to get the conditions. Numbers start at 0. |
| OUT | ||
| phSearchExp | int64 | 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 | 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 | int64 | 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 | int | 1 – Indicates that the complete expressions in the WHERE clause and JOIN condition are returned 0 – 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. |