Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

Null Values in Comparison Expressions

Null Values in Comparison Expressions

When you use a null value in an expression containing a comparison operator, the
PowerCenter Integration Service
produces a null value. However, you can also configure the
PowerCenter Integration Service
to treat null values as high or low in comparison operations.
Use the Treat Null In Comparison Operators As property to configure how the
PowerCenter Integration Service
handles null values in comparison expressions.
This
PowerCenter Integration Service
configuration property affects the behavior of the following comparison operators in expressions:
=, !=, ^=, <>, >, >=, <, <=
For example, consider the following expressions:
NULL > 1 NULL = NULL
The following table describes how the
PowerCenter Integration Service
evaluates the expressions:
Expression
Treat Null in Comparison Operators As
NULL
HIGH
LOW
NULL > 1
NULL
TRUE
FALSE
NULL = NULL
NULL
TRUE
TRUE