dam_describeJoinCond

This method is used by the IP when building a pushdown join result set. This method returns the description of the join condition. Use this method 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 =, > etc,) and the outer table column. The outer table column is identified by the outer table process order number and the schema column number.

Table 148. Parameters for dam_describeJoinCond
Parameter	Type	Description
INPUT
hstmt	long	The statement handle of the inner table that is being processed for building the pushdown join results.
OUTPUT
piInnerTableColNum	xo_int	The schema column number of a column of the inner table.
piOpType	xo_int	The operator type. The types are same as returned in dam_describeCond. SeeTable 144 for the operators and the associated value. BETWEEN type conditions are not considered as valid join conditions.
piOuterTableProcessOrder	xo_int	The table process order of the outer table whose column is used in join condition.
piOuterTableColNum	xo_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.