17.10 - Example: Using ISSCHEMAVALID to Check an XML Instance for Validity Against an XML Schema - 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)
SELECT customerID, customerXML.ISSCHEMAVALID(schematab.schemacontent, 'Customer', '')
FROM customer, schematab
WHERE schematab.schemaid = 'customerschema.xsd';

Query result:

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