XMLPI Syntax - Advanced SQL Engine - Teradata Database

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.