XML Query Using XPath and XQuery - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

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

The basic steps for querying XML content are:

  1. Compose an XPath or XQuery query and use BTEQ or SQL Assistant 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