16.20 - Overview of Methods on the XML Type - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference

Methods on the XML type support common XML operations like parsing, validation, transformation (XSLT) and query (XPath and XQuery).

Wherever string representations of XML values are required, you can use VARCHAR and CLOB typed values for small documents (<64K) and large documents (< 2GB).

IF you want to... THEN use this method...
add type annotations to an XML value CREATESCHEMABASEDXML
remove type annotations from XML values CREATENONSCHEMABASEDXML
execute an XSLT transform on the XML value using a specified stylesheet XSLTTRANSFORM
execute an XPath or XQuery query against the XML value XMLEXTRACT
check if a query will return a node EXISTSNODE
check if the XML value is a well-formed XML document ISDOCUMENT
check if the XML value is a document node with one or more child elements ISCONTENT
check if the XML value has been validated and has type annotations ISSCHEMAVALIDATED
check if the XML value is valid according to a specified schema ISSCHEMAVALID