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

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

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.