XMLPI Function | XML Data Type | Teradata Vantage - 17.10 - XMLPI - 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)

Creates an XML processing instruction node with the name determined by XML_PI_target.

XMLPI creates an XML processing instruction node with the name specified by XML_PI_target. char_value_expr is evaluated to a character string value using the rules for converting SQL data type values to XML values. A processing instruction node is constructed from the name and character string value so that its serialization is <? name character-string-value ?>. If this is not a well-formed XML 1.1 PI, an error is raised.

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.