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

Internationalization and the Transformation Language

Internationalization and the Transformation Language

Transformation language functions can handle character data in either ASCII or Unicode data movement mode. Use Unicode mode to handle
multibyte
character data. The return values of the following functions and transformations depend on the code page of the
PowerCenter Integration Service
and the data movement mode:
  • INITCAP
  • LOWER
  • UPPER
  • MIN (Date)
  • MIN (Number)
  • MIN (String)
  • MAX (Date)
  • MAX (Number)
  • MAX (String)
  • Any function that uses conditional statements to compare strings, such as IIF and DECODE
MIN and MAX also return values based on the sort order associated with the
PowerCenter Integration Service
code page.
When you validate an invalid expression in the Expression Editor, a dialog box displays the expression with an error indicator, “>>>>”. This indicator appears to the left of and points to the part of the expression containing the error. For example, if the expression a = b + c contains an error at c, the error message displays:
a = b +   >>>> c
Transformation language functions that evaluate character data are character-oriented, not byte-oriented. For example, the LENGTH function returns the number of characters in a string, not the number of bytes. The LOWER function returns a string in lowercase based on the code page of the
PowerCenter Integration Service
.