This function is only available when connected to a Teradata database.
The non-standard Teradata specific NULLIFZERO case expression is supported, generating SQL of the form NULLIFZERO (expression). It must be supplied exactly one argument. When dragging a Null If Zero into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - Case > Null If Zero
A column, and/or other expression can be moved over the (empty) branch of the tree.
The Null If element, which generates the standard NULLIF command, can be used in place of the Null If Zero element, which generates the non-standard Teradata specific command NULLIFZERO. In Teradata SQL, NULLIF(column1, 0) is equivalent to NULLIFZERO(column1).
There are no special properties for the Null If Zero function.