Null If Zero (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

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.