ABSENT.IGNORE

ABSENT.IGNORE

Top  Previous  Next

 

The ABSENT.IGNORE keyword suppresses the message at the end of a query command showing records that have not been found.

 

 

Format

 

ABSENT.IGNORE

 

 

The query processor normally builds a list of records that were specified on the command line or via a select list but were not found. This list is displayed on completion of the command. Sometimes it might be valid for the list to contain items that might not be present and should be ignored. In this case the list of unfound records is not required. The ABSENT.IGNORE keyword causes the query processor to ignore missing records.

 

 

Example

 

SELECT VOC

LIST NEWVOC

 

This pair of commands builds a list of all records in the VOC and then uses this list to display a report of the same records from the NEWVOC file. There will be records in the VOC that do not appear NEWVOC and a list of these will be shown on completion of the report.

 

 

SELECT VOC

LIST NEWVOC ABSENT.IGNORE

 

This pair of commands produces the same report but omits the list of records that were not found in NEWVOC.