Example: Validating an XML Document - Advanced SQL Engine - Teradata Database

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.