XSLT_SHRED Stored Procedure | XML Data Type | Teradata Vantage - 17.10 - XSLT_SHRED - 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)

Use the XSLT_SHRED stored procedure for XML shredding (extracting values from a single XML document to be used to populate the database), and is based on an XSLT stylesheet.

XSLT_SHRED returns a result code.

Required Privileges

The XSLT_SHRED stored procedure is created under the user TD_SYSXML.

The user invoking this stored procedure must have the following privileges:
  • EXECUTE PROCEDURE on TD_SYSXML
  • SELECT privilege on the staging table
  • GRANT ALL (insert/update/delete/upsert) on the target tables

XSLT_SHRED Shredding Mapping Definition

XSLT-based shredding is based on a mapping defined by XSLT stylesheet documents. The stylesheet defines how different parts of the XML document map to columns in target tables in a relational database. Shredding procedures interpret the stylesheet mappings as instructions on what data items to extract from XML documents and how to use those data items in updating the target tables.

The XSLT_SHRED mapping definition is similar to the mapping definition for XSLT_SHRED_BATCH, except for the following differences.
  • genexp is a mandatory attribute for all the elements under <Row>.
  • Only the <xsl:value-of> element can be used; <xsl:copy-of> is not allowed.
  • CLOB and BLOB are not supported in XSLT_SHRED.