16.20 - Converting XML Data to Relational Data - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

You can use the XMLTABLE function to convert an XML tree structure into zero or more rows:

  1. Compose an XQuery query that will generate a sequence. Each item of this sequence will generate a corresponding row.
  2. Determine the row format (column name, type of all the columns) and determine the path expression that will return the value of the column. The path expression should be relative to the items returned by the query in step (1).
  3. Compose a query which calls the XMLTABLE function to turn the XML documents into rows.