DataDirect OpenAccess SDK Help

damex_describeSelectTopClause

Save PDF

Save PDF

This function returns details of the TOP N clauses for a SELECT query. The TOP clause indicates the maximum number of rows to be returned.

Example queries:

SELECT TOP 10  * FROM emp;
SELECT TOP 5 PERCENT * FROM emp;

int damex_describeSelectTopClause(
    DAM_HQUERY  hquery,
    int64 *     piNumRows,
    int    *    pbPercent)

Parameters for damex_describeSelectTopClause

Parameter	Type	Description
IN
hquery	DAM_HQUERY	The query handle.
OUT
piNumRows	int64 *	The number of rows in the TOP clause. This number should be treated as a PERCENT if value of pbPercent is returned as TRUE.
pbPercent	int *	Indicates if TOP N number was specified with PERCENT option. Valid value are: TRUE FALSE
RETURN
	int	DAM_SUCCESS - on success DAM_FAILURE - on failure