XML Methods (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The following table lists the available methods on the XML type, and a description of their purpose.

XML, etc.: XML Methods
Function Description
XML Constructor Creates a new instance of the XML type.
CREATESCHEMABASEDXML Creates an XML value that is schema-validated and type-annotated.
CREATENONSCHEMABASEDXML Converts a schema-based XML value to one without type annotations.
EXISTSNODE Returns 1 if query returns other than NULL, an empty string or an empty sequence, or 0 otherwise.
ISCONTENT Returns 1 if the XML value is a document node with one or more child elements, or 0 otherwise.
ISDOCUMENT Returns 1 if the XML value is a well-formed XML document, or 0 otherwise.
ISSCHEMAVALID Returns 1 if the XML instance is valid against the given XML schema, or 0 otherwise.
ISSCHEMAVALIDATED Returns 1 if the XML value is schema-validated and type-annotated, or 0 otherwise.
XMLEXTRACT Evaluates an XPath or XQuery query against an XML type instance, returning the query result.
XSLTTRANSFORM Returns the XML type value resulting from an XSLT transformation of the XML type instance.
See the TeradataXML reference manual, B035-1140, for a detailed description of these XML methods.