XML Query Using XPath and XQuery

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

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