Table of Contents

Search

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

Transformation Language Reference

Transformation Language Reference

Nulls

Nulls

Expressions that combine a null value with a Boolean expression produce results that are ANSI compliant. For example, the
PowerCenter Integration Service
produces the following results:
  • NULL AND TRUE = NULL
  • NULL AND FALSE = FALSE