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

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

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