Changes to scalar functions in Db2 11.5.1

Db2 11.5.1 contains a number of new and changed scalar functions.

Attention: Changes in version 11.5.1 affect the following Db2 products:

Review the changes to learn which ones might affect your existing applications and to determine whether you have to adjust them.

Details

Changed scalar functions

Table 1. Changes to existing scalar functions
Scalar function	Description
LOWER	The `locale-name` attribute now accepts the value UNI_SIMPLE. This provides simple case folding mapping (case-insensitive Unicode string comparisons).
UPPER	The `locale-name` attribute now accepts the value UNI_SIMPLE. This provides simple case folding mapping (case-insensitive Unicode string comparisons).