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_SUBQUERY_CONDLISTS | Support for marking the 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 would use this option when dam_getSetOfConditionListsEx returns complete condition lists. Valid values are: |
| DAM_STMT_OPTION_DISTINCT | Determines whether the OpenAccess SDK SQL engine or the IP performs DISTINCT processing. The IP can use the dam_getInfo function to find out if a query has an optimizable SELECT DISTINCT clause. Valid values are: |
| DAM_STMT_OPTION_GROUP_BY | Determines whether the OpenAccess SDK SQL engine or the IP performs GROUP BY processing. Valid values are: |
| DAM_STMT_OPTION_ORDER_BY | Determines whether the OpenAccess SDK SQL engine or the IP performance ORDER BY processing. Valid values are: |
| 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 OAIP_execute is called with DAM_SET_QUERY_MODE. 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: dam_setOption returns DAM_NOT_AVAILABLE when query cannot be processed as Table Rowset. The IP should check the return status and modify its behavior based on if Table Rowset can be processed. |