The NULL function generates null values.

derive type:single value:NULL()

Output: Generates a column of null values.

derive type:single value: IF((ISNULL(FirstName) || ISNULL(LastName)), null(), 'ok') as:'status'

Output: If there are null values in either the FirstName or LastName column, generate a null value in the status column. Otherwise, the column value is ok.

There are no arguments for this function.

Example - Type check functions