16.20 - XMLQUERY - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

Purpose

Evaluates an XQuery query over the XML value.

Syntax





'xquery_expression'
The XQuery query string supplied as a character string literal.
xml query argument
An argument or list of arguments for the query.
BY VALUE
XML query arguments are passed in by value. This is the default.
XML_query_context_item

A value expression representing an XML query context item.

You can pass in only one context item.

XML_query_variable AS variable_name
An XML query variable in the format:
value_expression  AS  identifier
RETURNING CONTENT
The return value is a document node with one or more child element nodes.
RETURNING SEQUENCE
The return value is a sequence. This is the default.
NULL ON EMPTY
A NULL is returned if the query result is an empty sequence.
EMPTY ON EMPTY
An empty sequence is returned if the query result is an empty sequence.