PH28444: ABEND04E RC00E70005 DSNXGDT2 M112 DURING REBIND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 in DSNXGDT2 at logical offset M112 -112
  during a REBIND for a stored procedure package that contained
  an empty string ('') in the SELECT list of a FOR LOOP.  The
  empty string was not handled correctly and this abend was the
  result.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of native SQL                      *
  * procedure, compiled SQL scalar function,                     *
  * or advanced trigger with FOR statement in                    *
  * routine body.                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E RC00E70005 at the location                          *
  * DSNXGRDS DSNXGDT2 M112 could occur                           *
  * when rebinding , deploying a native                          *
  * SQL procedure, compiled SQL scalar                           *
  * function, or rebinding an                                    *
  * advanced trigger if the routine body                         *
  * contains a FOR statement with an                             *
  * empty string in the select list of the                       *
  *  select statement of the cursor.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The following example could recreate the abend:
  CREATE PROCEDURE MYTEST (INOUT NUM INT)
   L1: BEGIN
    LAB1: FOR f_vl AS cur_1 CURSOR FOR
            SELECT NULLIF('', '')
            AS NC  FROM SYSIBM.SYSDUMMY1
        DO
          INSERT INTO T1 VALUES ( f_vl.NC);
        END FOR;
   END L1
   REBIND PACKAGE(ADMF001.MYTEST.(*))
  Db2 didn't handle the empty string in FOR statement correctly
  during CREATE of the native SQL procedure which causing
  ABEND04E during REBIND.
  

Problem conclusion

• Db2 is updated to handle the aforementioned native SQL
  procedure, compiled SQL scalar function and advanced trigger
  correctly.
  Advanced keywords: SQLSP SQLSTOREDPROC SQLNATIVESQLPL SQLUDF
                     SQLTRIGGER SQLFOR SQLREBIND SQLDEPLOY
  

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:

  UI71386

Modules/Macros

• DSNXOYPA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI71386

     UP20/09/11 P F009

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.