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
|