Skip to Content

Default language.

Information
Limited support BMC 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 Check for Db2 13.1.

LOWER or LCASE

The LOWER function returns a string in which all characters have been converted to lowercase characters.

LOWERCASE.png

Warning

Important

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

LOWER or LCASE without UNI locale

The arguments are defined as follows:

stringExpression

The 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. If you do not specify this argument, the product treats the locale as blank.

The only accepted localeNameString types are:

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

LOWER or LCASE 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.

Warning

Important

  • 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*

BMC AMI Check for Db2 12.1