skip to main content
OpenAccess SDK SQL Engine core methods for .NET : Methods for .NET reference : dam_describeJoinCond
 

dam_describeJoinCond

This method is used by the IP when building 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 =, >, 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.
int dam_describeJoinCond(
int64 hstmt,
out int piInnerTableColNum,
out int piOpType,
out int piOuterTableProcessOrder,
out int piOuterTableColNum)
 
Table 114: Parameters for dam_describeJoinCond 
Parameter
Type
Description
IN
 
 
hstmt
int64
The statement handle of the inner table being processed for building the pushdown join results.
OUT
 
 
piInnerTableColNum
int
The schema column number of column of the inner table
piOpType
int
The operator type. The types are same as returned in dam_describeCond. BETWEEN type conditions are not considered as 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

See also 

dam_describeCond