XSLT Transformation | XML Data Type | Teradata Vantage - 17.10 - XSLT Transformation - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kxe1590704060061.ditamap
dita:ditavalPath
kxe1590704060061.ditaval
dita:id
dgs1472251600184
To transform an XML value using a stylesheet:
  1. Design the stylesheet and test it using tools such as Stylus Studio, XML Spy, or Oxygen.
  2. If the stylesheet contains includes, consolidate it using the Schema and Stylesheet Consolidation utility.
  3. Insert the stylesheet into a database table.
  4. Use the XSLTTRANSFORM method to transform the XML value. Join with the table containing the stylesheet to provide the stylesheet to the method.
You can download sample stylesheets and the Schema and Stylesheet Consolidation utility from Teradata Downloads.