PK82031: ABEND0C4 RC04 IN DSNXRXML+0E9C ON MERGE WITH XML HOSTVAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC04 in DSNXRXML+0E9C occurred when running a Merge
  statement with an XML data type Host variable.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users who use XML host variables     *
  *                 in MERGE statement                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND 0C4 at DSNXRXML could occur    *
  *                      when a MERGE statement contains  an     *
  *                      XML host variable in the USING clause.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND 0C4 at DSNXRXML could occur when a MERGE
  statement contains an XML host variable in the USING
  clause and the XML host variable is not nullable.
  
  The following is an example of the failed statement:
  MERGE INTO T1
   USING (VALUES(:int_hv, :xml_hv)) AS S(C1, X1)
   ON T1.C1 = S.C1
  WHEN MATCHED THEN UPDATE SET T1.X1 = S.X1
  WHEN NOT MATCHED THEN INSERT VALUES (S.C1, S.X1)
  
  Note if :xml_hv is replaced with :xml_hv:ind1, the
  XML host variable would be nullable type, then the
  ABEND would not happen.
  

Problem conclusion

• DB2 is modified to process XML host variable in the MERGE
  statement correctly.
  Additional keywords: SQLMERGE SQLHOSTVAR SQLXML
  

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:

  UK45800

Modules/Macros

• DSNXOB2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK45800

     UP09/04/30 P F904

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.