PQ57619: ABEND0C4-RC00000010 DSNXODTI+10F0 WHERE <CASE-EXPR.> IN (X,Y,Z)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4-00000010 LOC=DSNXODTI+10F0
  SQL causes dump: WHERE <CASE-expr.> IN (x,y,z)
  For example:
  SELECT
     ...
  WHERE CASE WHEN .... THEN
                 ...
        END IN ( ... )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL DB2 R510 USERS                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4-RC00000010 DSNXODTI+10F0       *
  *                      when a query has a where clause with    *
  *                      a case expression followed by an IN     *
  *                      keyword.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following query caused an ABEND04C in DSNXODTI.
  SELECT *
    FROM T1
  WHERE
     CASE
        WHEN T1.COL1 LIKE 'COL%'
        THEN SUBSTR(T1.COL1, 1,2)
        ELSE SUBSTR(T1.COL1, 1,3)
      END IN ('COS', 'CSR', 'ICA', 'PAS', 'PSC', 'TMP');
  
  The LIKE predicate in the CASE is causing DB2 to process the
  IN predicate as if it was a LIKE predicate.
  

Problem conclusion

• The logic is modified so that the WHERE clause with a CASE
  expression with LIKE followed by an IN is processed correctly.
  
  Additional keywords: SQLLIKE, SQLIN, SQLCASE
  

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:

  UQ64784

Modules/Macros

•    DSNXOEX  DSNXOEXG
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R510 PSY UQ64784

     UP02/04/23 P F204

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.