Syntax
IS_NULL_IND(Argument)
Description
The IS_NULL_IND SQL scalar function returns a boolean value that indicates when a column contains the NULL value.
The argument must be an array's column.
The result is the boolean value *TRUE when the column contains the NULL value, else *FALSE.
Example
Retrieve orders with shipping dates missing:
CURSOR C1 ORDER *COND(IS_NULL_IND(ORD_SHIP_DATE))
List of SQL scalar functions by topic