DB2 FOR LUW / DB2FORLUW / A10 - DB2

Merge command with insert  in xml column return error SQL16084N. 
 
When run a sql command like example below with a insert in a xml 
column: 
 
MERGE INTO 
WHEN NOT MATCHED 
THEN INSERT (XML_column) VALUES ( '<Cust><addr></addr></Cust>') 
 
Return Error: 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL16084N  An assigned value in the copy clause of a transform 
expression is 
not a sequence with exactly one item that is a node. Error 
QName=err:XUTY0013. 
SQLSTATE=10705

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See problem description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1FP4.                                      * 
****************************************************************

The error will stop to happen after inserting the first record 
in 
the table with xml column, after that the merge command can run 
without problem.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in Version 10.1FP4.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.12.2013
15.12.2014
15.12.2014