XML Shredding and Publishing | XML Data Type | Teradata Vantage - 17.10 - XML Shredding and Publishing - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Advanced SQL Engine
Teradata Database
Release Number
July 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)
This section describes the XML shredding and publishing process and the stored procedures that provide this functionality:
  • XML publishing stored procedures allow you to publish the results of an SQL query in XML format:
  • XML shredding stored procedures load XML documents into relational tables:
    • The AS_SHRED_BATCH stored procedure provides streamed shredding functionality with the mapping provided as an annotated schema.
    • The XSLT_SHRED and XSLT_SHRED_BATCH stored procedures provide shredding functionality with the mapping provided as an XSLT stylesheet. XSLT_SHRED is used for single XML document shredding and XSLT_SHRED_BATCH is used to shred multiple XML documents. In comparison to streamed shredding, the XSLT-based shredding procedures load the document being shredded into memory. While this requires more memory, it makes shredding more flexible.