NO.NULLS

The NO.NULLS keyword suppresses null items.

Format

NO.NULLS

The NO.NULLS keyword has three uses:

1.With the query processor AVERAGE, ENUMERATE, MEDIAN, MIN and MODE keywords, this keyword ignores null items.

2.With the query processor SAVING keyword, this keyword omits null field values from the generated select list.

3.With the CREATE.INDEX command, it omit records with null field values from the index.