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

dam_getSetOfConditionListsEx

This method is used to retrieve expressions from the WHERE clause on one or more columns in the form of AND or OR expressions. It can be used to retrieve all the expressions in the WHERE clause by passing in NULL for the column handle.
As in the case of the condition list returned by dam_getRestrictionList, each of the condition lists contained in this set can be marked as evaluated by using the dam_setOption method.
The OpenAccess SDK SQL Engine handles all condition lists not marked as evaluated. This feature can be used to take a look at all the available expressions but only handle the ones it can. If the condition list returned is a partial list, as indicated by the pbPartialLists output, then the OpenAccess SDK SQL Engine evaluates all the conditions. When finished with the list, the IP must call dam_freeSetOfConditionList to free the set of conditions list.
See "Advanced Optimization" in Chapter 4 of the OpenAccess SDK SQL Engine Programmer’s Guide for more information.
int64 dam_getSetOfConditionListsEx(
int64 hstmt,
int iType,
int hcol,
out int pbPartialLists)
 
Table 179: Parameters for dam_getSetOfConditionListsEx 
Parameter
Type
Description
IN
 
 
hstmt
int64
The statement handle
iType
int
The type of condition list requested:
SQL_SET_CONDLIST_INTERSECT – transform the where clause into set of AND conditions and return these as a list. This is valid only if IP_SUPPORT_UNION_CONDLIST is set to 0.
SQL_SET_CONDLIST_UNION – transform the where clause into a set of OR conditions and return these as a list. This is valid only if IP_SUPPORT_UNION_CONDLIST is set to 1.
hcol
int
The column to retrieve expressions on. Set to 0 to specify all columns.
OUT
 
 
pbPartialLists
int
1 – the condition list provided to the IP is a partial list. This happens in cases where the query contains expressions like (A=B). In this case, the OpenAccess SDK SQL Engine builds temporary condition lists which contain all the conditions that can be exposed to IP. The IP cannot mark these condition lists as evaluated. The OpenAccess SDK SQL Engine will be forced to evaluate all the original condition lists of the search expression.
0 – the condition list provided to the IP contains the full expression.
RETURN
 
 
 
int64
The search condition list. Navigate it by using the dam_getFirstCondList and dam_getNextCondList methods. A NULL is returned if no search list is available. The IP must call dam_freeSetOfConditionList to this handle when finished with the query.

See also 

• dam_freeSetOfConditionList
• dam_getFirstCondList
• dam_getNextCondList
• dam_getRestrictionList
• dam_setOption