The following programs demonstrate the use of the MISSING and
NOT MISSING conditional expressions. These programs form a record
stream containing the records in the COLLEGES relation that have
nothing stored in the field STATE, but do have a college code
stored in the field COLLEGE_CODE. Each record in the COLLEGES
relation is tested for the above condition; if a record meets the
condition these programs print an informational message and the
college code of the newest record added to the record stream.
Additional Information:
explode
extract