PI90322: ABEND04E RC00E70005 DSNXGSPL M700 WITH CREATE or ALTER PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXGSPL M700 with CREATE or ALTER PROCEDURE
  when the procedure body contains an IF statement which meets the
  pattern in the following example:
  
  CREATE PROCEDURE MYPROC1(INOUT P1 INT)
  LANGUAGE SQL
  P1:BEGIN
    IF 1=1 OR 2=2 THEN
     SELECT 1231 INTO P1 FROM SYSIBM.SYSDUMMY1;
    END IF;
  END P1!
  END IF;
  
  Additional Keywords:    SQLSP SQLSTOREDPROC
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 11 for z/OS, DB2 12 for z/OS users                   *
  * of native SQL PL procedue, compiled SQL                      *
  * scalar function, Advanced trigger which                      *
  * contains always true predicate in its                        *
  * control statement.                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An ABEND04E RC00E70005 at location                           *
  * DSNXGRDS DSNXGSPL M700 may occur when                        *
  * a native SQL PL procedure, compiled                          *
  * SQL scalar function, Advanced trigger                        *
  * contains a control statement                                 *
  * satisfies the following                                      *
  * condition:                                                   *
  * 1. It contains always true predicate,                        *
  * like 1=1.                                                    *
  * 2. The always true predicate is under                        *
  * OR boolean term.                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The control statement satisfies the following conditions:
  1. It contains always true predicate, like 1=1.
  2. The always true predicate is under OR boolean term.
  
  The following example could recreate the ABEND:
  CREATE PROCEDURE MYPROC1(INOUT P1 INT)
  LANGUAGE SQL
  P1:BEGIN
  IF 1=1 OR P1=2 THEN
  SELECT 1231 INTO P1 FROM SYSIBM.SYSDUMMY1;
  END IF;
  END P1!
  
  DB2 abend because it doesn't handle the always true predicate
  correctly.
  

Problem conclusion

• DB2 is updated to handle the always true predicate correctly
  in SQL PL procedure, compiled SQL scalar function and
  advanced trigger.
  Additional Keywords: SQLNATIVESQLPL SQLUDF SQLTRIGGER
  

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:

  UI53121 UI53123

Modules/Macros

• DSNXOYPC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI53121

     UP18/01/26 P F801

• RB10 PSY UI53123

     UP18/01/26 P F801

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.