dam_getRestrictionList

This function is used to get the handle to the list of restriction conditions on a column when using the INTERSECTION condition list. This function is used with the function dam_getOptimalIndexAndConditions to process as few rows as possible.

When using restriction lists, a row is built for evaluation if, and only if, it matches a search condition (returned by dam_getOptimalIndexAndConditions), and it matches at least one restriction condition in each of the restriction lists. The IP navigates through the search condition list, if there is one, returned by dam_getOptimalIndexAndConditions. For each search condition, the IP builds rows that satisfy at least one condition in each of the restriction lists.

Related functions:

• Use this function with dam_getFirstCond, dam_getNextCond, and dam_describeCondEx.
• Use dam_getRestrictionList on other columns to further restrict the number of rows processed.
• Use the function dam_setOption to mark a restriction expression as evaluated by the IP to prevent the OpenAccess SDK SQL engine from attempting to evaluate it.

DAM_HCONDLIST dam_getRestrictionList(
    DAM_HSTMT hstmt, 
    DAM_HCOL  hcol)

Parameters for dam_getRestrictionList

See also

• dam_getFirstCondList
• dam_getNextCondList
• dam_describeCondEx
• dam_getOptimalIndexAndConditions
• dam_getRestrictionList
• dam_setOption