OpenAccess SDK SQL Engine Core Functions API : Function Reference : dam_getRestrictionList

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)

Table 151. Parameters for dam_getRestrictionList
Parameter	Type	Description
IN
hstmt	DAM_HSTMT	The statement handle.
hcol	DAM_HCOL	The handle of the column for which the restriction is requested.
RETURN
	DAM_HCONDLIST	The restriction condition list. Navigate it by using the dam_getFirstCond and dam_getNextCond functions. A NULL is returned if no restrictions apply on the specified column.

dam_getRestrictionList

See also