Convert the data in the Table into XML format

Database
Enthusiast

Convert the data in the Table into XML format

HI All,

I'm trying to convert the data in a table to XML format for an application. And the output I get is <Error>.

Also , when i try to run the below statement i am gettting the same:

SELECT XMLELEMENT(NAME "Item", XMLATTRIBUTES('001' AS ID));.

Looks like I am missing something. Can someone helpme out in resolving the same. 

2 REPLIES
Teradata Employee

Re: Convert the data in the Table into XML format

Don't use a quoted identifier for the XML Element Name.

Enthusiast

Re: Convert the data in the Table into XML format

Tried that as well. But doesn't help...