Null Values

Omnidex supports nulls in a limited capacity. Null values cannot be indexed. NULL values in indexed fields are converted to zeros, blanks or empty strings, depending on the data type.

Optimized queries will not honor NULL values. Non-optimized queries support NULL values as follows:

• IS [NOT] NULL operator in WHERE clause predicates
• NULLs in AVG aggregations
• NULLs in join operations
• NULL is supported as a field value for inserting and updating records, to the extent that the underlying database supports NULL values.

UPDATE customers set contact=NULL where customer_no=2000

When the underlying database is flat files, a search for a null value will result in no qualified records.

Top