skip to main content
SQL Engine parse tree methods for Java : damex_describeTableJoinInfo
 

damex_describeTableJoinInfo

This method retrieves the outer/inner join information for a join query. If no outer/inner join exists, a 0 is returned for phJoinExp.
void damex_describeTableJoinInfo(
     long   hTable,
     xo_int piJoinType,
     long   phJoinExp)
Table 267. Parameters for damex_describeTableJoinInfo
Parameter
Type
Description
INPUT
hTable
long
The table handle.
OUTPUT
piJoinType
xo_int
The type of the join:
SQL_JOIN_LEFT_OUTER - left outer joinSQL_JOIN_RIGHT_OUTER - right outer join
SQL_JOIN_FULL_OUTER - full outer join
SQL_JOIN_INNER - inner join
phJoinExp
long
The handle to the join expression in the ON clause of the join. A 0 is returned if no outer/inner join exists.