16.20 - Example: Validating an XML Document - 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)

In this query, the ISSCHEMAVALID method is used to validate the XML document in the customer table using the schema stored in the schematab table.

SELECT customerID, customerXML.ISSCHEMAVALID(schematab.schemaContent, 'Customer', '')
FROM customer, schematab
WHERE schematab.schemaid = 'customerschema.xsd';

The result of the query is:

customerID  customerXML.ISSCHEMAVALID(schemaContent, 'Customer', '')
-----------  --------------------------------------------------------
          1                                                         1

The ISSCHEMAVALID method returned a value of 1 indicating that the XML document is valid based on the schema.