CREATESCHEMABASEDXML Syntax - Analytics Database - Teradata Vantage

Teradata Vantage™ - XML Data Type - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
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.