PM87679: ABEND0C4 RC4 AT DSNXOPRS OFFSET 8F4C

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC4 AT DSNXOPRS OFFSET 8F4C
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 and DB2 11 for z/OS users who use *
  *                 CASE expression in a BETWEEN predicate       *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4 RC4 AT DSNXOPRS 8F4C may occur *
  *                      for a query that uses CASE expression   *
  *                      in a non-correlated BETWEEN predicate   *
  *                      and JOIN on multiple tables.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
   Here is an example to show the failing case.
  
    =========
     EXAMPLE
    =========
  
    CREATE TABLE MYTBA (A1 INT, A2 INT, A3 INT, A4 INT);
    CREATE TABLE MYTBB (B1 INT);
    CREATE TABLE MYTBC (C1 INT);
    CREATE TABLE MYTBD (D1 INT);
    COMMIT;
  
    SELECT 'TEST'
      FROM MYTBA
           LEFT OUTER JOIN
           MYTBB
        ON A1 = B1
           LEFT OUTER JOIN
           MYTBC
        ON A1 = C1,
           MYTBD
     WHERE D1 BETWEEN CASE WHEN A1 = 1
                           THEN A2
                           ELSE A3
                         END
                  AND A4;
  

Problem conclusion

• DB2 code has been modified to handle the aforementioned problem
  correctly.
  
  Additional keywords: SQLCASE SQLBETWEEN SQLJOIN SQLNONCORRSUBQ
  

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:

  UK96313 UK96314

Modules/Macros

• DSNXOEXB DSNXOW2C DSNXOW2D
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK96313

     UP13/08/15 P F308

• RB10 PSY UK96314

     UP13/08/15 P F308

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.