PH19888: DB2 12 FOR Z/OS NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 12 for z/OS new function
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of the UPPER,                      *
  * LOWER, and TRANSLATE scalar functions.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR adds support of a new locale                       *
  * value 'UNI_60' for the CURRENT                               *
  * LC_CTYPE special register and the                            *
  * locale argument of the UPPER, LOWER,                         *
  * and TRANSLATE scalar functions.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Db2 currently allows the value 'UNI_SIMPLE' or 'UNI' as a
  locale to indicate that Db2 should use z/OS Unicode Conversion
  Services to perform the upper or lower conversion with "normal"
  or "normal" and "special" casing capabilities.  Locale 'UNI'
  uses Unicode version 3.0.0 (DEFAULT for z/OS Unicode Services)
  and 'UNI_SIMPLE' uses the latest version of the Unicode
  Standard that z/OS Unicode Conversion Services supports.
  In this APAR, support of a new locale 'UNI_60' is being added.
  'UNI_60' means that z/OS Unicode Conversion Services would be
  used with only "normal" casing capabilities and use Unicode
  Standard 6.0.0.
  

Problem conclusion

Temporary fix

Comments

• In this APAR, support of a new locale 'UNI_60' is being
  added. 'UNI_60' means that z/OS Unicode Conversion Services
  will be used with only "normal" casing capability and
  Unicode Standard 6.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_SIMPLE' can be specified as a locale name will be
  modified to allow 'UNI_60'. 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_60 - The conversion uses Unicode Standard 6.0.0 and
    the NORMAL casing capability as described in z/OS
    Unicode Services User's Guide and Reference:  Select
    the conversions.  UNI_60 cannot be used with EBCDIC
    data.
  This enhancement is applicable to Db2 12 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:

  UI68327

Modules/Macros

• DSNXRDBC DSNXRSBC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI68327

     UP20/03/21 P F003

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.