SQL Engine Parse Tree API : SQL Engine Parse Tree functions reference : damex_isTableSubQuery

damex_isTableSubQuery

This function checks if the table is a subquery. For example, for the following query, you use this function to determine whether subqry1 is a table subquery:

SELECT * FROM (SELECT * FROM tab1) subqry1

If no table handle is found, this function returns NULL.

DAM_HQUERY dam_isTableSubQuery(DAM_HTABLE htable)

Table 233. Parameters for dam_isTableSubQuery
Parameter	Type	Description
IN
hTable	DAM_HTABLE	A handle to the table. If not found, NULL.
RETURN
	Int	DAM_TRUE - The table is a subquery. DAM_FALSE - The table is not a subquery.