null()

The Null() function determines whether a value specified by the parameter is null or not.

Example of the NULL Function Translation
Service Manager function Translated SQL equivalent:
select ps.number, ps.title from probsummary ps where null(ps.assignment)
select t01.”NUMBER”, t01.”TITLE” from PROBSUMMARYM1 t01 where t01.”ASSIGNMENT” is NULL

The parameter can only be a field name or an expression that can be evaluated beforehand; It cannot be an expression that cannot be evaluated before translation into SQL:

The following cases are valid:
null( ps.category )    //In this example, “category” is a field from “probsummary” file.
null( $L.var )    //In this example, $L.var is a local variable defined beforehand.
The following cases are invalid:
null ( ps.title + ps.brief )
null ( ps.title + $L.var )