XMLCONCAT Function | XML Data Type | Teradata Vantage - XMLCONCAT - Analytics Database - Teradata Vantage

XML Data Type

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-10-30
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
lifecycle
latest
Product Category
Teradata Vantageā„¢

Generates a forest of XML values given a list of values as parameters.

XMLCONCAT takes a number of expressions as parameters. Each of these expressions results in a sequence. An item is equivalent to a sequence containing just that item. A NULL is treated like an empty sequence.

The result is a sequence containing the items in all the sequences in order.

The semantics of XML concatenation are specified in pairs where if either of the pair resolves to a NULL, the result is the other value. If both are NULL, the result is a NULL. Therefore in the event that all XML_value expr arguments are NULL, the result is a NULL.

Result Type

The return value is of XML type. The return value is based on the RETURNING clause. If the clause is not specified, the default is RETURNING SEQUENCE.