Methods on the XML Type | XML Data Type | VantageCloud Lake - Methods on the XML Type - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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).

CREATESCHEMABASEDXML
Adds type annotations to XML value.
CREATENONSCHEMABASEDXML
Removes type annotations from XML values.
EXISTSNODE
Checks if query returns a node.
ISCONTENT
Checks if XML value is adocument node with one or more child elements.
ISDOCUMENT
Checks if XML value is well-formed XML document.
ISSCHEMAVALID
Checks if XML value is valid according to a specified schema.
ISSCHEMAVALIDATED
Checks if XML value has been validated and has type annotations.
XMLEXTRACT
Runs XPath or XQuery query against XML value.
XSLTTRANSFORM
Runs XSLT transform on XML value using specified stylesheet.