Storing XML in teradata

Database
Enthusiast

Storing XML in teradata

Hi

I am interested in being able to store an XML string (actually the XML text of a SOAP request) in teradata, and would like to be able to query it as an XML document. Does teradata have any facilities to work with XML?

Cheers
1 REPLY
Enthusiast

Re: Storing XML in teradata

Do you want TD to just "store" the XML document, not process any XML tags or so ? ... in that case you will have to make use of CLOB/BLOB and develop custom JDBC/ODBC apps to do the task ...

Else if you are looking to process the tags in the XML file, then you might find some information in this thread to start with.

http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=11&messageid=7814