PI41169: ABEND04E RC00E70005 AT DSNXGRDS DSNXGSFN M405 WHEN PREDICATE CONTAINS SUBSTR WHICH REFERENCES COLUMN DEFINED FOR BIT DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 at DSNXGRDS DSNXGSFN M405 when predicate
  contains SUBSTR function which references column defined FOR BIT
  DATA
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of a SQL statement *
  *                 containing a predicate with a SUBSTR         *
  *                 function which references a column defined   *
  *                 as FOR BIT DATA                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 at location      *
  *                      DSNXGRDS DSNXGSFN M405 may occur        *
  *                      when a predicate contains SUBSTR which  *
  *                      references a column defined as          *
  *                      FOR BIT DATA                            *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND04E RC00E70005 at location DSNXGRDS DSNXGSFN M405
  may occur when a predicate contains SUBSTR which references
  a column defined as FOR BIT DATA.
  
  The following example helps to illustrate the problem.
  
  Step 1: Create object.
  CREATE TABLE T1 (
    C1 VARCHAR(10) FOR BIT DATA,
    C2 INT
  );
  
  Step 2: Statement which may issue ABEND.
  DCL CHARHV1 CHAR(2);
  DCL CHARHV2 CHAR(10);
  
  EXEC SQL
  SELECT 'AA' INTO :CHARHV1
  FROM T1
  WHERE SUBSTR(C1, 1, 4) = SUBSTR(:CHARHV2, 1, 4);
  
  Note: In the above case, we will have no column expression
  

Problem conclusion

• DB2 has been modified to correct an ABEND04E RC00E70005
  at location DSNXGRDS DSNXGSFN M405.
  
  Additional keywords: SQLWHERE  SQLCCSID ABEND04E RC00E70005
                       in DSNXGSFN M405  SQLSUBSTR
  

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:

  UI30035

Modules/Macros

• DSNXGSFN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI30035

     UP15/08/23 P F508

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.