NAFLAG

Used for debugging and testing variables defined with nulltracking, the function identifies whether or not a value is a NA2 value or a non-NA value.

Return Values

INTEGER

0 for a non-NA value, 2 if the NA value is an NA2 value, or 1 for all other NA values

Syntax

NAFLAG (expression)

Arguments

expression

An OLAP DML expression.

Examples

See Example 9-103, "Defining a Variable with Null Tracking"