skip to main content
SQL Engine parse tree methods for .NET : SQL pass-through and advanced query methods reference : damex_describeValExp
 

damex_describeValExp

This method retrieves the description of the value expression. The value expression has one of the following formats:
value
function(value): – functions: MIN, MAX, AVG, SUM, COUNT, VAR, VAR_SAMP, STDDEV, STDDEV_SAMP, STDEV, VARP, VAR_POP, STDDEVP, STDDEV_POP, STDEVP
COUNT(*)
val_exp {+ | – | * | /} val_exp
scalar_val_exp
int damex_describeValExp(
int64 hValExp,
out int piType,
out int piFuncType,
out int64 phLeftValExp,
out int64 phRightValExp,
out int64 phVal,
out int64 phScalarValExp)
 
Table 226: Parameters for damex_describeValExp 
Parameter
Type
Description
IN
 
 
hValExp
int64
The value expression handle.
OUT
 
 
piType
int
The type of the value expression:
SQL_VAL_EXP_VAL
SQL_VAL_EXP_ADD
SQL_VAL_EXP_SUBTRACT
SQL_VAL_EXP_MULTIPLY
SQL_VAL_EXP_DIVIDE
SQL_VAL_EXP_SCALAR
piFuncType
int
The type of the set function can be a bitwise OR of the following values:
SQL_F_COUNT_ALL
SQL_F_COUNT
SQL_F_MIN
SQL_F_MAX
SQL_F_AVG
SQL_F_SUM
SQL_F_DISTINCT
SQL_F_VAR
SQL_F_VARP
SQL_F_STDDEV
SQL_F_STDDEVP
This value will be zero if no set function exists.
phLeftValExp
int64
The handle to the left value expression. This value is set only when the val expression type is one of the following:
SQL_VAL_EXP_ADD
SQL_VAL_EXP_SUBTRACT
SQL_VAL_EXP_MULTIPLY
SQL_VAL_EXP_DIVIDE
Otherwise the value is zero.
phRightValExp
int64
The handle to the right value expression. This value is set only when the value expression type is one of the following:
SQL_VAL_EXP_ADD
SQL_VAL_EXP_SUBTRACT
SQL_VAL_EXP_MULTIPLY
SQL_VAL_EXP_DIVIDE
Otherwise the value is zero.
phVal
int64
The handle to the value. This value is set only when the value expression type is SQL_VAL_EXP_VAL. Use damex_describeVal to get the details of the value.
phScalarValExp
int64
The handle to the scalar value. This value is set only when the value expression type is SQL_VAL_EXP_SCALAR.
Use damex_describeScalarValExp to get the details of the scalar method.
Use damex_getFirstValExp and damex_getNextValExp to navigate the argument list returned by damex_describeScalarValExp.
RETURN
 
 
 
int
DAM_SUCCESS – on success
DAM_FAILURE – on failure

See also 

damex_describeVal
damex_getFirstValExp
damex_getNextValExp
damex_describeScalarValExp