PK88508: INCORRECT OUTPUT FROM LOWER (LCASE) BUILT-IN FUNCTION ON DBCS EBCDIC DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrect output from LOWER (LCASE) built-in function on EBCDIC
  DBCS data.
  DB2INCORR/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of LOWER built-in function with    *
  *                 EBCDIC DBCS input argument for MIXED=YES     *
  *                 SYSTEMS only.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect output is returned from the   *
  *                      LOWER (or LCASE) built-in function when *
  *                      input to the function is EBCDIC graphic *
  *                      string (DBCS string).                   *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Incorrect output is returned from the LOWER (or LCASE) built-in
  function when input to the function is EBCDIC graphic string.
  Instead of LOWER function, an UPPER function is performed,
  causing an incorrect result.
  
  The following example (for a MIXED=YES system) helps to
  demonstrate the problem:
  
    SET CURRENT LOCALE LC_CTYPE = 'KO_KR';       -- set locale
  
    SELECT HEX(GRAPHIC('A')) as MAJ,             -- upper case
           HEX(GRAPHIC('a')) as MIN,             -- lower case
           HEX(LOWER(GRAPHIC('Aa'))) as LOWER    -- LOWER function
    FROM SYSIBM.SYSDUMMY1;
  
    Expected result is:
     +-------------------------+
     | MAJ  | MIN  |  LOWER    |
     +-------------------------+
   1_| 42C1 | 4281 | 42814281  |
     +-------------------------+
  
    However, incorrect result is returned:
     +-------------------------+
     | MAJ  | MIN  |  LOWER    |
     +-------------------------+
   1_| 42C1 | 4281 | 42C142C1  |
     +-------------------------+
  

Problem conclusion

• Code in DB2 was changed to properly handle the LOWER function
  for EBCDIC DBCS input strings.
  
  ADDITIONAL KEYWORDS:  SQLLCASE SQLLOWER SQLUPPER SQLUCASE
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK48110 UK48111

Modules/Macros

• DSNXHLL  DSNXLECC DSNXRLES DSNXRLET DSNXVCCV
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK48110

     UP09/07/22 P F907

• R910 PSY UK48111

     UP09/07/22 P F907

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.