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
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)
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.