To transform an XML value using a stylesheet:
- Design the stylesheet and test it using tools such as Stylus Studio, XML Spy, or Oxygen.
- If the stylesheet contains includes, consolidate it using the Schema and Stylesheet Consolidation utility.
- Insert the stylesheet into a database table.
- 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.