DB2 - Problembeschreibung
Problem IC98175 | Status: Geschlossen |
Merge command with insert in an XML column returns error SQL16084N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When running a SQL command like example below with an insert using an 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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 Fix Pack 3. * **************************************************************** | |
Local-Fix: | |
The error will stop happening after inserting the first record in the table with an xml column. After that the merge command can run without problem. | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
First fixed in Version 10.5 Fix Pack 3. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 06.12.2013 28.12.2014 28.12.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |