CREATESCHEMABASEDXML Syntax - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kxe1590704060061.ditamap
dita:ditavalPath
kxe1590704060061.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.