skip to main content
SQL Engine Parse Tree API : SQL Engine Parse Tree functions reference : damex_describeTableJoinInfo
 

damex_describeTableJoinInfo

This function is used to retrieve the outer/inner join information for a join query. If no outer/inner join exists, NULL value is returned for phJoinExp.
void damex_describeTableJoinInfo(
    DAM_HTABLE hTable,
    int * piJoinType,
    DAM_HLOGEXP * phJoinExp)
Table 198. Parameters for damex_describeTableJoinInfo
Parameter
Type
Description
IN
hTable
DAM_HTABLE
The table handle.
OUT
piJoinType
int *
The type of the join:
*SQL_JOIN_LEFT_OUTER - left outer join
*SQL_JOIN_RIGHT_OUTER - right outer join
*SQL_JOIN_FULL_OUTER - full outer join
*SQL_JOIN_INNER - inner join
*SQL_JOIN_OLD_STYLE - inner join
phJoinExp
DAM_HLOGEXP *
The handle to the join expression in the ON clause of the join.
A NULL is returned if no outer/inner join exists.
RETURN
NONE