db2 not forming tree view of xml data

nitin257 · #1 (**permalink**) 09-09-08, 02:08

Hello Everyone

I am using sql/xml query to retrieve xml data from db2 but every time i try to see returned results db2 posts message

Quote:

DBA8010N The tree view of the XML document cannot be built.

Explanation:

Explanation: The document may be corrupted.

User response:

Ensure that the document is well-formed and that the character encoding
is set correctly.

But it works fine if i use xquery

Please help me out,i have to use sql/xml query

stolze · #2 (**permalink**) 09-09-08, 08:00

Do you care to give us some more information like sample data, queries, DB2 version and platform?

Internet Services

Web Development

Digital Marketing

Consumer Tech