|
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.
|