The UPPER function returns a string in which all the characters have been converted to uppercase characters, based on the CCSID of the argument. Only SBCS and Unicode graphic characters are converted. The characters a-z are converted to A-Z, and characters with diacritical marks are converted to their uppercase equivalent, if any.
Refer to the UCS-2 level 1 mapping tables topic of the Globalization topic collection for a description of the monocasing tables that are used for this translation.
The result of the function has the same data type, length attribute, actual length, and CCSID as the argument. If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Syntax alternatives: UCASE is a synonym for UPPER.
SELECT UPPER('abcdef') FROM SYSIBM.SYSDUMMY1Returns the value 'ABCDEF'.
SELECT
UPPER(
)
FROM SYSIBM.SYSDUMMY1
Returns
the value: 