dam_describeJoinCond
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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.
int dam_describeJoinCond(
long hstmt,
xo_int piInnerTableColNum,
xo_int piOpType,
xo_int piOuterTableProcessOrder,
xo_int piOuterTableColNum)
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. See Table Operator Types for Conditions 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. |
|