Usage Notes - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.