PI41432: ABEND04E RC00E70005 DSNXOGA P001 WITH INLIST AND FIELDPROC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• COL1 and COL2 defined with FIELDPROC
  
  SELECT ..
  
  WHERE
     (
      (COL1 IN ('AAA','BBB'))
    OR
  
     (COL2 IN ('AAA', 'BBB'))
     )
  
  generates abend
  DUMP TITLE=DSN ,ABND=04E-00E70005,U= ,M=C  ,C=111.RDS -R
             SCTCACH,M=DSNTFRCV,LOC=DSNXGRDS.DSNXOGA :P001
  

Local fix

• rewrite the query to OR instead of INLIST
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of an SQL          *
  *                 statement containing non boolean term        *
  *                 IN-LIST predicate which references a column  *
  *                 defined with FIELDPROC.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 at location      *
  *                      DSNXGRDS DSNXOGA P001 may occur when    *
  *                      an SQL statement contains non boolean   *
  *                      term IN-LIST predicate which references *
  *                      a column defined with FIELDPROC.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following example helps to illustrate the problem.
  
  CREATE TABLE T1  (
    C1 VARCHAR(10),
    C2 CHAR(12) FIELDPROC FPCVD4
   );
  
  SELECT C1, C2
    FROM T1
  WHERE C2 IN('133', '123', '333') OR C1 = '33';
  
  DB2 does not process the IN-LIST predicate which references
  a column defined with FIELDPROC properly which can result
  in the described ABEND.
  

Problem conclusion

• DB2 has been modified correctly to process the IN-LIST predicate
  which references a column defined with FIELDPROC to avoid the
  described ABEND.
  
  Additional keywords: SQLIN SQLOR SQLFIELDPROC
  

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:

  UI28959

Modules/Macros

• DSNXOSP1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI28959

     UP15/07/15 P F507

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.