|
Problem IC63259
|
Status: Geschlossen |
XQUERY OR SQL/XML MIGHT ISSUE UNEXPECTED SQLCODE SQL16002N |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
Abstract: XQuery or SQL/XML using "element", "attribute" or
"processing-instruction" at the end of XPath might issue
unexpected sqlcode SQL16002N.
Description:
When user writes a XQuery or SQL/XML using "element",
"attribute" or "processing-instruction" at then end of XPath,
they might get unexpected sqlcode SQL16002N.
For example,
xquery
for $d in db2-fn:xmlcolumn('TAB1.XMLDOC')/xpath/element
return <item> {$d} </item>
;
xquery
for $d in db2-fn:xmlcolumn('TAB1.XMLDOC')/xpath/attribute
return <item> {$d} </item>
;
xquery
for $d in
db2-fn:xmlcolumn('TAB1.XMLDOC')/xpath/processing-instruction
return <item> {$d} </item>
;
UPDATE tab1
SET xmldoc = XMLQUERY('copy $new := $XMLDOC
modify do replace value of
$new/xpath/processing-instruction with
"testvalue"
return $new')
; |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* XQUERY OR SQL/XML MIGHT ISSUE UNEXPECTED SQLCODE SQL16002N *
****************************************************************
* RECOMMENDATION: *
* LOCAL FIX: *
* this issue has no local fix. *
* *
* Fixed in V9.7 FP1 *
**************************************************************** |
| Local-Fix: |
this issue has no local fix. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
ERROR DESCRIPTION:
Abstract: XQuery or SQL/XML using "element", "attribute"
or
"processing-instruction" at the end of XPath might issue
unexpected sqlcode SQL16002N. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.09.2009
04.02.2010
04.02.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
