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

UPPER

UPPER

Converts lowercase string characters to uppercase.

Syntax

UPPER(
string
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
string
Required
String datatype. Passes the values you want to change to uppercase text. You can enter any valid transformation expression.

Return Value

Uppercase string. If the data contains multibyte characters, the return value depends on the code page and data movement mode of the
PowerCenter Integration Service
.
NULL if a value passed to the function is NULL.

Example

The following expression changes all names in the FIRST_NAME port to uppercase:
UPPER( FIRST_NAME )
FIRST_NAME
RETURN VALUE
Ramona
RAMONA
NULL
NULL
THOMAS
THOMAS
PierRe
PIERRE
Bernice
BERNICE