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>