XMLQUERY

Teradata Vantageā„¢ XML Data Type

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

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.