Retrieving XML Data | Teradata Vantage - Retrieving XML Data - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kxe1590704060061.ditamap
dita:ditavalPath
kxe1590704060061.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢

You can retrieve XML data as an entire document or as query results.

XML values returned from the database might not be well-formed XML documents as defined by the XML 1.0 and XML 1.1 specifications. For example, XML queries can return sequences or atomic values that might not have a well-formed XML representation. Note that parsing errors can occur in these cases. You can either include these results into other XML documents through entity references or using string concatenation. You can also modify queries so that well-formed XML is returned.

XML values are always returned in non-Field Mode.