17.10 - CREATESCHEMABASEDXML Syntax - 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)
CREATESCHEMABASEDXML ( schema )

Syntax Elements

schema
The schema to use to validate the XML value.
The data type of the input argument schema must be XML type. If schema is NULL or is not a valid schema, an error is raised.
The schema should be stored as an XML type value in a table with a unique identifier associated with it. When invoking this method, you can join the schema table and specify the schema by its unique identifier in the WHERE clause.
If schema is composed of a single schema document (the schema document does not include or import another schema document), you can pass the schema document as an XML type value to this method.
If schema consists of more than one document, then do the following:
  1. Use the Schema and Stylesheet Consolidation utility to consolidate the schema document.
  2. Pass the consolidated schema document as an XML type value to this method.