XMLPI Function | XML Data Type | Teradata Vantage - XMLPI - 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ā„¢

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

Syntax

XMLPI (
  NAME XML_PI_target
  [, char_value_expr ]
  [ RETURNING { CONTENT | SEQUENCE } ]
)
XML_PI_target

A valid XML 1.1 NCName.

It should not be the string 'xml' in any upper or lower case combination. For example, 'xml', 'XML', and 'Xml' are not valid.

char_value_expr
A string used to construct the processing instruction node.
RETURNING CONTENT
The return value is an XQuery document node with the PI as its child.
RETURNING SEQUENCE
The return value is a sequence with the PI as its only item. This is the default.