skip to main content
SQL Engine parse tree methods for Java : 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(
    int    hquery,
    xo_int piSetQuantifier,
    long   phSelectValExpList,
    long   phSearchExp,
    long   phGroupValExpList,
    long   phHavingExp,
    long   phOrderValExpList)
Table 263. Parameters for damex_describeSelectQuery
Parameter
Type
Description
INPUT
hquery
int
The query handle.
OUTPUT
piSetQuantifier
xo_int
The quantifier of the result set:
SQL_SELECT_ALL - return all rows. Do not eliminate any duplicates from the result table.
SQL_SELECT_DISTINCT - eliminate any duplicate rows from the result table.
phSelectValExpList
long
The handle to the select list. Use damex_getFirstValExp, damex_getNextValExp to navigate the select list.
phSearchExp
long
The handle to the search expression in the WHERE clause. Use damex_describeLogicExp to get details of the logical search expression.
phGroupValExpList
long
The handle to the value-exp list of the GROUP BY clause. Use damex_getFirstValExp and damex_getNextValExp to navigate the GROUP BY expressions.
phHavingExp
long
The handle to the HAVING clause expression. Use damex_describeLogicExp to get details about the logical HAVING expression.
phOrderValExpList
long
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_describeValExp
*damex_getFirstTable
*damex_getNextTable
*damex_getFirstValExp
*damex_getNextValExp