17.10 - Example: Using XMLVALIDATE to Validate XML Values - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)

This query validates the XML values in the customerXML column of the customer table using the schema in the schemacontent column of the schematab table for the row where the schemaid column has the value 'customerschema.xsd'. The resulting column are copies of the XML values with type annotations.

SELECT XMLVALIDATE(DOCUMENT customer.customerXML ACCORDING TO XMLSCHEMA VALUE schematab.schemacontent)
FROM customer, schematab
WHERE schematab.schemaid = 'customerschema.xsd';

Here are partial results from the query. The ellipsis (...) is not part of the query results. It indicates that the query returns additional results that are truncated in the example.

XMLVALIDATE(DOCUMENT customerXML ACCORDING TO XMLSCHEMA VALUE...
----------------------------------------------------------------
<Customer>  <Name>John Hancock</Name>  <Address>100 1st Street, San Francisco, CA 94118</Address>  <Phone1>(858)555-1234</Phone1>  <Phone2>(858)555-9876</Phone2>  <Fax>(858)555-9999</Fax>  <Email>John...