PH47187: NEW DEVELOPMENT FOR UNI_90 LOCALE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New development for UNI_90 Locale
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 and 13 for z/OS users of the                      *
  * UPPER, LOWER, and TRANSLATE scalar                           *
  * functions.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR adds support of a new locale                       *
  * value 'UNI_90' for the CURRENT                               *
  * LC_CTYPE special register and the                            *
  * locale argument of the UPPER, LOWER,                         *
  * and TRANSLATE scalar functions.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In this APAR, support of a new locale 'UNI_90' is being added.
  'UNI_90' means that z/OS Unicode Conversion Services would be
  used with only "normal" casing capabilities and use Unicode
  Standard 9.0.0.
  

Problem conclusion

Temporary fix

Comments

• In this APAR, support of a new locale 'UNI_90' is being
  added. 'UNI_90' means that z/OS Unicode Conversion Services
  will be used with only "normal" casing capability and
  Unicode Standard 9.0.0.
  The following Db2 publication changes are also being made
  with respect to this new support.
  Simply, all sections of the SQL Reference which document
  where 'UNI_60' can be specified as a locale name will be
  modified to allow 'UNI_90'. These include:
  1. The CURRENT LOCALE LC_CTYPE special register.
  2. The LOWER built-in scalar function.
  3. The UPPER built-in scalar function.
  4. The TRANSLATE built-in scalar function.
    UNI_90 - The conversion uses Unicode Standard 9.0.0 and
    the NORMAL casing capability as described in z/OS
    Unicode Services User's Guide and Reference:  Select
    the conversions.  You must not specify UNI_90 when
    string-expression is EBCDIC data.
  This enhancement is applicable to Db2 12 and 13 at the
  APPLCOMPAT LEVEL V12R1M500 or higher.
  Additional Keywords: SQLSPECIALREG SQLLOCALE SQLBIF
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI82392 UI82393

Modules/Macros

• DSNXRDBC DSNXRSBC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI82392

     UP22/09/21 P F209

• RD10 PSY UI82393

     UP22/09/21 P F209

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.