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.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.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.