Statement Options for dam_setOption
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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 whether the IP has taken care of DISTINCT processing. 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 whether the IP has taken care of GROUP BY processing. |
| DAM_STMT_OPTION_ORDER_BY | Indicate to the OpenAccess SDK SQL engine whether the IP has taken care of ORDER BY processing. |
| 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 would use 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: If Table Rowset is being processed, the IP should not operate in Cursor Mode. The IP should process and add all rows before returning from IP execute. 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. |