A fix is available
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 number
PH47187
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-06-13
Closed date
2022-09-13
Last modified date
2022-10-03
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 October 2022