[SQL] Combining XML files Using SQL

I want to combined mulitple exisiting xml format files into one xml output file.

I am a new deveolper and still learning.

I have a table with four coloums - ROWID, XMLMESSAGE, BUS_DTE, DW_LOD.

I want to produce a query in teradata that will put several XML messages into one single XML output message.

My current approach is:

SELECT XMLSERIALIZE( DOCUMENT XMLELEMENT(NAME "XML_MESSAGES", XMLAGG(XMLMSG) ) AS VARCHAR(20000) ) AS transactions_xml FROM <Database.Table>;

All i get is syntax after syntax eerror after every edit i make and i am not sure on how to approach this problem.

Any guidence is hugely appricated.

Continue reading...