Statement Options
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
For the statement options, set the option type to DAM_STMT_OPTION and the object handle to the current statement handle.
Statement options for dam_setOption
| Option (iOption) | Option Value |
| DAM_STMT_OPTION_DISTINCT | Indicate to the OpenAccess SDK SQL Engine not to perform DISTINCT processing because the IP has taken care of it. The IP can use the dam_getInfo method to find out if a query has an optimizable SELECT DISTINCT clause. |
| DAM_STMT_OPTION_GROUP_BY | Indicate to the OpenAccess SDK SQL Engine not to perform GROUP BY processing because the IP has taken care of it. |
| DAM_STMT_OPTION_ORDER_BY | Indicate to the OpenAccess SDK SQL Engine not to perform ORDER BY processing because the IP has taken care of it. |
| DAM_STMT_OPTION_PASSTHROUGH_ QUERY |
When working in Query Selection Mode, the IP sets this option to tell the OpenAccess SDK SQL Engine which mode the IP wants to handle the query in. Set this option when ipExecute is called with DAM_SET_QUERY_MODE. Valid values are: |
| DAM_STMT_OPTION_SUBQUERY_ CONDLISTS | Support for marking entire list of condition lists of subquery as “Evaluated” by the IP so that the OpenAccess SDK SQL Engine skips evaluation during dam_isTargetRow. The IP uses this option when dam_getSetOfConditionListsEx returns complete condition lists. Valid values are: |
| DAM_STMT_OPTION_TABLE_ ROWSET | When operating in BLOCK JOIN mode, this option determines whether the OpenAccess SDK SQL Engine or the IP returns Table Rowset results. Valid values are: |