Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

damex_describeValExp

  • Last Updated: May 12, 2026
  • 2 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

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)

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 successDAM_FAILURE – on failure

    See also

    TitleResults for “How to create a CRG?”Also Available inAlert