dam_describeJoinCond

This function is used by the IP when building pushdown join result set. This function returns the description of the join condition. Use this function to find out what the join condition is innertable.col = outertable.col. The join condition is returned as a condition on a column of the inner table, the condition type (=, NOT =, > and so on), and the outer table column. The outer table column is identified by the outer table process order number and the schema column number.

Table 83. Parameters for dam_describeJoinCond
Parameter	Type	Description
IN
hstmt	DAM_HSTMT	The statement handle of the inner table being processed for building the pushdown join results.
OUT
piInnerTableColNum	int *	The schema column number of a column of the inner table.
piOpType	int *	The operator type, as described in Table 80, and the same as those returned in dam_describeCondEx. BETWEEN type conditions are not considered valid join conditions.
piOuterTableProcessOrder	int *	The table process order of the outer table whose column is used in join condition.
piOuterTableColNum	int *	The schema column number of the outer table column.
RETURN
	int	DAM_SUCCESS - valid join condition returned DAM_NOT_AVAILABLE - no clear join condition can be returned DAM_FAILURE - error

dam_describeJoinCond

See also