Document Retrieval - Analytics Database - Teradata Vantage

Teradata Vantage™ - XML Data Type - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
Product Category
Teradata Vantage

The following sections show how users can store XML documents into XML type columns and retrieve them via SQL queries that either retrieve the entire document or evaluate an XPath/XQuery expression that returns a single document node.

Consider the following queries:
SELECT id, xmldoc FROM xmltab;
SELECT id, xmldoc.xmlextract('.', NULL) FROM xmltab;

The result of each query represents a single tree rooted in a document node. The server returns the serialized representation of the document. The serialization of the document is not guaranteed to be lexically equivalent to the document that was inserted, but it will be semantically equivalent (the canonical representation of the original document that was inserted and the document retrieved will be lexically equivalent). Drivers can either parse the document returned or pass on the stream to applications.