LOWER or LCASE - Documentation for BMC AMI Check for Db2 12.1

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

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.

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