The UPPER function is identical to the TRANSLATE function except that only the first argument (char-string-exp) is specified.

The schema is SYSIBM.
(The SYSFUN version of this function continues to be available for upward compatibility.)

expression

An expression that returns either a Boolean value or a built-in character string that is not FOR BIT DATA.
In a Unicode database, the expression can also return a graphic string, in which case it is first converted to a character string before the function is evaluated.

Related reference

• TRANSLATE scalar function
• UPPER (locale sensitive) scalar function