Overview of Methods on the XML Type

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

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