XML Shredding and Publishing

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
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.