PM94974: ABEND04E RC00E70005 AT DSNXRLOB P017 FOR AN SQL STATEMENT WITH AN UPPER CAST FUNCTION AND A LOB OBJECT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 AT DSNXRLOB :P017 FOR A SQL STATEMENT WITH
  AN UPPER CAST FUNCTION AND A LOB OBJECT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users who use  *
  *                 the UPPER function in a LIKE predicate with  *
  *                 a LOB object                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E70005 in DSNXRLOB P017    *
  *                      may occur when the UPPER function is    *
  *                      used in a LIKE predicate with a LOB     *
  *                      object.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Here is an example to show the failing case.
  
   =========
    EXAMPLE
   =========
  
   CREATE TABLE MYTABLE (C1 CLOB(6));
  
   SELECT 'TEST' FROM MYTABLE
    WHERE C1 LIKE UPPER('%T%');
  

Problem conclusion

• DB2 code has been modified to handle the aforementioned problem
  correctly.
  
  Additional keywords: SQLWHERE SQLLIKE SQLLOB
  

Temporary fix

Comments

APAR Information

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

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

  UK98190 UK98191

Modules/Macros

• DSNXOW2D
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK98190

     UP13/10/18 P F310

• R910 PSY UK98191

     UP13/10/18 P F310

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.