Zero If Null (Teradata Database) - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.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 ZEROIFNULL case expression is supported, generating SQL of the form ZEROIFNULL (expression). It must be supplied exactly one argument. When dragging a Zero If Null into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Case > Zero If Null

A column, and/or other expression can be moved over the (empty) branch of the tree.
The Coalesce element, which generates the standard COALESCE command, can be used in place of the Zero If Null element, which generates the non-standard Teradata specific command ZEROIFNULL. In Teradata SQL, COALESCE(column1, 0) is equivalent to ZEROIFNULL (column1).

There are no special properties for the Zero If Null function.