SELECT xml2clob(xmlelement(NAME "Languages ", xmlagg(newele)))
FROM
(
SELECT xml2clob(
xmlelement(NAME "Language ", xmlattributes(ltable.returnedVarchar AS "Value "),
xmlagg(
xmlelement(NAME "Book ",
(SELECT titable.returnedVarchar FROM
TABLE(db2xml.extractVarchars(xmldoc, '/Book/@Title ')) AS titable)))
)) AS newele
FROM xmlcol,TABLE(db2xml.extractVarchars(xmldoc, '/Book/@OriginalLanguage ')) AS ltable
)
GROUP BY ltable.returnedVarchar
想要得到这样的结果:
<languages>
<language value= "xxx ">
<book> aaa </book>
</language>
</languages>
但上面那段代码怎么都通不过,说GROUP BY语句有问题。
大家能不能帮忙想想办法?
多谢。
------解决方案--------------------------------------------------------
www.mydb2.cn上的应用开发版有些XML开发相关的资料下载。