Format

      MISSING_VALUE IS  value-expr

1  –  Parameters

1.1  –  value-expr

    Specifies an expression a product can use to calculate a field's
    value. See Expressions for more information on value expressions.

2  –  Description

    The MISSING_VALUE field property specifies a value to use if a
    field has not been assigned a meaningful value. See the DIGITAL
    DATATRIEVE or Oracle Rdb documentation for more information on
    how those products interpret the MISSING_VALUE field property.

    The expression you specify must be a valid expression for the
    product evaluating it.

    Products using CDO ignore field elements that contain the
    MISSING_VALUE field property when performing statistical
    operations.

3  –  Examples

    1.CDO>  DEFINE FIELD PRICE
      cont>  DATATYPE IS SIGNED LONGWORD
      cont>  MISSING_VALUE IS 0.

      In this example, the DEFINE FIELD command includes a MISSING_
      VALUE field property that can assign a value of 0 to a null or
      missing value.

    2.CDO>  CHANGE FIELD PRICE
      cont>   NOMISSING_VALUE.

      In this example, the NOMISSING_VALUE keyword removes the
      MISSING_VALUE property from the PRICE field element.