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

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)
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:
    • XMLPUBLISH_STREAM
    • XMLPUBLISH
  • 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.