DTRHELP.HLB  —  Commands Statements Clauses, MISSING VALUE Clause
       Designates a value for a field that DEC DATATRIEVE recognizes,
       not as the literal value, but as a marker that no value is
       stored in the field. DEC DATATRIEVE ignores fields containing the
       "missing value" marker when evaluating statistical expressions
       (AVERAGE, MAX, MIN, TOTAL, and STD_DEV).

       When you store a record and do not directly assign a value to
       a field with a MISSING VALUE defined, DEC DATATRIEVE uses the
       missing value to initialize the field if it contains no DEFAULT
       VALUE clause.

       Format

         MISSING  [VALUE [IS]] literal

1  –  Arguments

    VALUE IS

       Are optional keywords you can use to clarify the syntax of the
       clause.

    literal

       Is either a numeric or character string literal.

2  –  Examples

       The following example defines a record that contains MISSING
       VALUE clauses:

       DTR> DEFINE DOMAIN THINGS USING THINGREC ON THINGS;
       DTR> DEFINE RECORD THINGREC USING
       DFN> 01 THINGS.
       DFN>    03 NUM PIC 9(5)
       DFN>       MISSING VALUE IS 11111
       DFN>       EDIT_STRING IS ZZ,Z99?"***MISSING***".
       DFN>    03 STR PIC X(10) MISSING VALUE IS "EMPTY"
       DFN>       EDIT_STRING IS X(10)?"***MISSING***".
       DFN> ;

       DTR>

       The following example defines a new domain based on YACHTS that
       uses a new missing value and a MISSING VALUE edit string:

       DTR> DEFINE DOMAIN YACHTS_PRICE_LIST USING YPL_REC ON YPL.DAT;
       DTR> DEFINE RECORD YPL_REC USING
       DFN> 01 BOAT.
       DFN>    03 TYPE.
       DFN>       05 BUILDER PIC X(10).
       DFN>       05 MODEL PIC X(8).
       DFN>    03 PRICE PIC 9(5) MISSING VALUE IS 0
       DFN>       EDIT_STRING $$$,$$$?"NOT LISTED".
       DFN> ;
       [Record is 23 bytes long.]
       DTR> DEFINE FILE FOR YACHTS_PRICE_LIST KEY = TYPE
       DTR> READY YACHTS_PRICE_LIST AS YPL WRITE
       DTR> READY YACHTS
       DTR> YPL = YACHTS WITH LOA GT 35
       DTR> FIND YPL WITH PRICE MISSING
       [12 records found]
       DTR> PRINT FIRST 3 CURRENT

        BUILDER    MODEL     PRICE

       BLOCK I.   40       NOT LISTED
       CABOT      36       NOT LISTED
       DOWN EAST  38       NOT LISTED

       DTR>
Close Help