skip to main content
SQL Engine parse tree methods for .NET : SQL pass-through and advanced query methods reference : damex_describeSelectQuery
 

damex_describeSelectQuery

This method returns details about the SELECT query. To get the list of tables on the SELECT query, use damex_getFirstTable and damex_getNextTable.
int damex_describeSelectQuery(
int64 hquery,
out int piSetQuantifier,
out int64 phSelectValExpList,
out int64 phSearchExp,
out int64 phGroupValExpList,
out int64 phHavingExp,
out int64 phOrderValExpList)
 
Table 219: Parameters for damex_describeSelectQuery 
Parameter
Type
Description
IN
 
 
hquery
int64
The query handle.
OUT
 
 
piSetQuantifier
int
The quantifier of the result set:
SQL_SELECT_ALL – return all rows. Do not eliminate any duplicates from the resulting table.
SQL_SELECT_DISTINCT – eliminate any duplicate rows from the result table
phSelectValExpList
int64
The handle to the select list. Use damex_getFirstValExp, damex_getNextValExp to navigate the select list.
phSearchExp
int64
The handle to the search expression in the WHERE clause. Use damex_describeLogicExp to get details of the logical search expression.
phGroupValExpList
int64
The handle to the value-exp list of the GROUP BY clause. Use damex_getFirstValExp, damex_getNextValExp to navigate the GROUP BY expressions.
phHavingExp
int64
The handle to the HAVING clause expression. Use damex_describeLogicExp to get details about the logical HAVING expression.
phOrderValExpList
int64
The handle to the value-exp list of the ORDER BY clause. Use damex_getFirstValExp and damex_getNextValExp to navigate the ORDER BY expressions.
RETURN
 
 
 
int
DAM_SUCCESS – on success
DAM_FAILURE – on failure

See also 

damex_describeLogicExp
damex_getFirstTable
damex_getFirstValExp
damex_getNextValExp
damex_getNextTable