PI74799: ABEND04E RC00E70005 DSNXOEER DSNXEFDA M500 CALLER IS DSNXOBFC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXOEER DSNXEFDA M500 caller is DSNXOBFC .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of a native SQL    *
  *                 procedure or compiled SQL scalar function    *
  *                 that contains an array constructor.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E70005 at the location     *
  *                      DSNXOEER DSNXEFDA M500 could happen     *
  *                      when creating a native SQL procedure or *
  *                      compiled SQL scalar function that       *
  *                      contains an array variable as the       *
  *                      operand of an array constructor.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An example is shown below:
  
  CREATE TYPE ARTYP1 AS VARCHAR(40) ARRAY  10 #
  CREATE TYPE ARTYP2 AS INT ARRAY  10 #
  
  CREATE PROCEDURE SP1(P1 VARCHAR(30))
  BEGIN
    DECLARE AR1 ARTYP1;
    DECLARE AR2 ARTYP2;
  
    SET AR2 = ARRAY AR1 ;
  END
  #
  
  SQLCODE461 should be issued for the above SET statement, while
  DB2 did not correctly process it and resulted in the abend.
  

Problem conclusion

• DB2 has been modified to correctly process the aforementioned
  SQL statement, and SQLCODE461 will be correctly issued.
  
  Additional keywords: SQLSP SQLSTOREDPROC SQLNATIVESQLPL
  

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:

  PI75072 UI45140

Modules/Macros

• DSNXOARR DSNXOBFC DSNXOCF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI45140

     UP17/03/25 P F703

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.