|
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_PROCESS_ON (default) – the OpenAccess SDK SQL Engine handles the processing.
• DAM_PROCESS_OFF – the IP has performed the processing.
|
|
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_PROCESS_ON (default) – the OpenAccess SDK SQL Engine handles the processing
• DAM_PROCESS_OFF – the IP has performed the processing
|
|
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_PROCESS_ON (default) – the OpenAccess SDK SQL Engine handles the processing.
• DAM_PROCESS_OFF – the IP has performed the 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_PROCESS_ON – the IP wants to handle the query in SQL pass-through mode.
• DAM_PROCESS_OFF –the IP continues working in normal row-based mode.
|
|
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_PROCESS_ON (default) – the OpenAccess SDK SQL Engine handles the evaluation.
• DAM_PROCESS_OFF – the IP performs the processing.
|
|
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_PROCESS_ON (default) – the OpenAccess SDK SQL Engine handles the processing.
• DAM_PROCESS_OFF – the IP has performed the processing.
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.
|