17.10 - XMLPI Syntax - 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)
XMLPI (
  NAME XML_PI_target
  [, char_value_expr ]
  [ RETURNING { CONTENT | SEQUENCE } ]
)

Syntax Elements

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.

The data type of XML_PI_target is VARCHAR.
char_value_expr
A string used to construct the processing instruction node.
The data type of char_value_expr is CLOB, CHAR(n), or VARCHAR(n), where n is as close to 64K as permitted. If the type is CLOB, it cannot be larger than 64K.
If char_value_expr is NULL, the function returns NULL.
If char_value_expr is omitted, it is treated as a zero-length string.
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.