skip to main content
OpenAccess SDK SQL Engine Core Functions API : Function Reference : dam_setJoinOrder
 

dam_setJoinOrder

This function is used to set the join order for the tables in the query. This function is called for each table present in the query. The sequence in which it is called dictates the join order for those tables. The tables of the Select query can be accessed using dam_getJoinQuery first for getting Query handle, and damex_getFirstTable and damex_getNextTable for getting tables in the Select Query.
int dam_setJoinOrder(DAM_HTABLE htable)
Table 174. Parameters for dam_setIP_hcol
Parameter
Type
Description
IN
htable
DAM_HTABLE
The statement handle.
RETURN
int
Status of the function call:
DAM_SUCCESS - Value is associated
DAM_FAILURE - Error

See also

*dam_getJoinQuery
*damex_getFirstTable
*damex_getNextTable