Example: Using XMLVALIDATE to Validate XML Values

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

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...