value
function(value) - function: 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
|
Parameter
|
Type
|
Description
|
|
IN
|
||
|
hValExp
|
DAM_HVALEXP
|
Value expression handle.
|
|
OUT
|
||
|
piType
|
int *
|
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
SQL_VAL_EXP_CASE,
SQL_VAL_EXP_RANK
|
|
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 is NULL if no set function exists.
|
|
phLeftValExp
|
DAM_HVALEXP *
|
The handle to the left 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
The value is NULL otherwise.
|
|
phRightValExp
|
DAM_HVALEXP *
|
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
SQL_VAL_EXP_CASE,
SQL_VAL_EXP_RANK
The value is NULL otherwise.
|
|
phVal
|
DAM_HVAL *
|
The handle to the value. This value is set only when the value expression type is SQL_VAL_EXP_VAL.
|
|
phScalarValExp
|
DAM_HSCALAR_VALEXP *
|
The handle to the scalar value. This value is set only when the value expression type is SQL_VAL_EXP_SCALAR.
Use damex_getFirstValExp, damex_getNextValExp to navigate the argument list.
|
|
phCaseValExp
|
DAM_HCASE_VALEXP *
|
The handle to the case value. This value is set only when the value expression type is SQL_VAL_EXP_CASE.
Use damex_describeCaseValExp to get details.
|
|
RETURN
|
||
|
int
|
DAM_SUCCESS - on success
DAM_FAILURE - on failure
|