Null Handling (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

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

The following table lists the available null handling functions, and a description of their purpose.

Embedded Services: Null Handling Functions
Function Description
NVL Replaces a NULL with a numeric or a string value as the result value.
NVL2 Returns one of two values based on whether or not expr1 is NULL.
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these null handling functions.