IS.NULL()

The IS.NULL() function tests whether a data item holds the SQL style null value.

Format

IS.NULL(var)

where

var	is the variable to be tested.

QM provides very limited support for the SQL style null data value. This is intended for use only with the JPARSE() and JBUILD() functions where it is necessary to parse and rebuild a JSON string that contains null items.

The IS.NULL() function tests whether a variable contains the SQL style null value.