XMLELEMENT - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

Purpose

Constructs an XML element node.

Syntax





You can include only one default namespace declaration item. It can appear in any position in the list of comma-separated namespace declarations or at the end of the list.
XML_element_name
The name of the element.
XML namespace declaration

XML namespaces that are scoped when the query expressions (row and column) are evaluated.

Namespaces declared in the prolog of the queries override any namespace declarations specified here.
'XML_namespace_URI'
The URI (Uniform Resource Identifier) that identifies the XML namespace.
XML_namespace_prefix
The URI (Uniform Resource Identifier) that identifies the XML namespace.
XML_attribute_value
A value for an attribute of the element.
XML_attribute_name
A name for the attribute. The name cannot be 'xmlns' and no two attributes can have the same qualified name (for example, same namespace and local name).
XML_value_expr
An instance of the XML type representing the XML element content.
OPTION
NULL ON NULL
EMPTY ON NULL
ABSENT ON NULL
NIL ON NULL
NIL ON NO CONTENT
XML content options.
RETURNING CONTENT
The return value is a document node with one or more child element nodes.
RETURNING SEQUENCE
The return value is a sequence (an ordered collection of items, each of which can either be a valid Xquery node or atomic value). This is the default.