The basic steps for querying XML content are:
- Compose an XPath or XQuery query and use BTEQ or SQL Assistant to test it against XML documents in the database.
-
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