XMLCONCAT Function | XML Data Type | Teradata Vantage - 17.10 - XMLCONCAT - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)

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.