PM95205: ABEND04E RC00E70005 DSNXESX2 M999 WHEN CREATING A STORED PROC WITH A MERGE STATEMENT THAT REFERENCES A TABLE WITH A FIELDPROC.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 at DSNXESX2 M999 when creating a stored
    procedure with a MERGE statement that references a table with a
    fieldproc. (D161083)
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS users of queries          *
    *                 with a MERGE statement that references       *
    *                 a table with a field procedure.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 can occur at     *
    *                      DSNXESX2 M999 for a query that contains *
    *                      a MERGE statement that references a     *
    *                      table with a field procedure.           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND04E RC00E70005 can occur at location DSNXESX2 M999 for a
    query that contains a MERGE statement with an UPDATE operation
    for the MATCHED condition.  This UPDATE is to update a column in
    the table which contains a field procedure (fieldproc).
    
    The failure occurs on behalf of the UPDATE operation for the
    MATCHED condition for the MERGE statement.
    
    
    
    The following query helps to illustrate a failing example.
    
    1. Create Table MYT1 with a field procedure on column C2.
    
      CREATE TABLE MYT1( C1 INTEGER,
                         C2 CHAR(2)     NOT NULL FIELDPROC FPALL5,
                         C3 VARCHAR(4))
    
    2. Execute the following MERGE statement.
    
          MERGE INTO MYT1
            USING ( VALUES (TEMP_C1, TEMP_C2, TEMP_C3 ) )
                      AS T (T_C1, T_C2, T_C3)
                 ON ( MYT1.C1 = T.T_C1)
                   WHEN MATCHED THEN UPDATE   <= MATCHED condition
                      SET ( C2, C3)
                        = (T.T_C2, T.T_C3)
                   WHEN NOT MATCHED THEN INSERT
                          (C2, C3)
                    VALUES(T.T_C2, T.T_C3) ;
    
    
    The failure above can occur for the UPDATE operation in the
    MATCHED condition for the MERGE statement.  The UPDATE is for
    column C2 from Table MYT1 which contains a fieldproc definition.
    
    In a static SQL case, the abend at DSNXESX2 M999 can occur with
    the above MERGE statement.
    
    In a dynamic SQL case, the above MERGE statement can receive an
    SQLCODE -682 (SQLCODE682) when executed.
    

Problem conclusion

  • The code in DB2 has been modified to initialize local variables
    properly when processing a FIELD PROCEDURE (fieldproc) to
    prevent the failure.
    
    Additional Keywords: SQLFIELDPROC SQLSTOREDPROC SQLMERGE
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM95205

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-15

  • Closed date

    2013-09-20

  • Last modified date

    2013-11-04

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK97747

Modules/Macros

  • DSNXGMVE
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK97747

       UP13/10/08 P F310

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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM95205

Modified date:

2013-11-04

Translate my page

Machine Translation

Content navigation