XML Query Using XPath and XQuery | XML Data Type | Teradata Vantage - XML Query Using XPath and XQuery - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kxe1590704060061.ditamap
dita:ditavalPath
kxe1590704060061.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢
The basic steps for querying XML content are:
  1. Compose an XPath or XQuery query and use BTEQ to test it against XML documents in the database.
  2. Depending on the intended use, you can use these methods and functions to evaluate the XML queries:
    • XMLEXTRACT method
    • EXISTSNODE method
    • XMLQUERY function
    • XMLTABLE function