|
Problem IC63259
|
Status: Closed |
XQUERY OR SQL/XML MIGHT ISSUE UNEXPECTED SQLCODE SQL16002N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
ERROR DESCRIPTION:
Abstract: XQuery or SQL/XML using "element", "attribute"
or
"processing-instruction" at the end of XPath might issue
unexpected sqlcode SQL16002N. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.09.2009
04.02.2010
04.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
