Default language.

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Utility Manager for Db2 13.1.

UPPER or UCASE

The UPPER or UCASE function returns a string in which all the characters have been converted to uppercase characters.

UPPERCASE.png

Important

If the argument can be null, the result can be null; if argument value is null, the result is the null value.

UPPER or UCASE without UNI locale

The arguments are defined as follows:

stringExpression

stringExpression can be one of the following:

  • CHAR SBCS in EBCDIC encoding scheme
  • VARCHAR SBCS in EBCDIC encoding scheme

localeNameString

LocaleNameString is a string constant in EBCDIC that specifies a valid locale name. you do not specify the localeNameString argument, the products treats the locale as blank.

The only accepted localeNameString types are:

  • Blank—SBCS lowercase characters A-Z are converted to SBCS uppercase characters.
  • EN_US—SBCS lowercase characters A-Z are converted to SBCS uppercase characters.
  • DE_DE—SBCSDeutsch lowercase characters are converted to Deutsch SBCS uppercase characters.

UPPER or UCASE with UNI locale

The arguments are defined as follows:

stringExpression

stringExpression can be defined in the Unicode encoding scheme, and in one of the following data types:

  • CHAR SBCS or mixed
  • VARCHAR SBCS or mixed
  • GRAPHIC or VARGRAPHIC

UNI

Currently the BMC AMI Utilities SQL language supports only the UNI locale.

length

The length argument defines the length of the output expressed in bytes. The result string is padded when there is a varying source string.

Note:

  • length is supported only for the UNI locale.
  • The value of length cannot exceed 255 for stringExpression when defined as a CHAR value, and cannot exceed 32704 for a varying string.
  • The length argument must be a positive integer constant.
  • The value of length must be bigger than the length of the source string. If less, the function returns an error.


Related topics

Functions-that-the-BMC-AMI-Utilities-SQL-language-supports

Features-that-the-BMC-AMI-Utilities-SQL-language-supports



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*