Example: Using ISDOCUMENT to Check if an XML Value is a Well-formed XML Document

Teradata Vantage™ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
SELECT customerXML.ISDOCUMENT()
FROM customer
WHERE customerID = 1;

Query result:

customerXML.ISDOCUMENT()
------------------------
                       1