NO.NULLS

NO.NULLS

Top  Previous  Next

 

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.