Generate XML Stylesheet Transformation - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Generate XSLT Wizard guides you through the steps to create an XML Stylesheet Transformation (XSLT). To launch the wizard, select the Generate XML Stylesheet Transformation menu option.

The Generate XSLT Wizard uses the SQL statement you select from the SQL file to generate a Canonical (or Source) XML Schema Definition (XSD) and prompts you for the Target XML Schema Definition (XSD). It then invokes the Teradata XSLT Generator which allows you to map elements from the source XSD to the target XSD and generate the XSLT.

After the XSLT is generated, the wizard prompts you for a stylesheet name and then registers the XSLT in Teradata. The wizard also provides an option to save the stylesheet to a file on the file system, as well as an option to open the XSLT.

To generate the Canonical XSD, the command calls the SYSXML GEN_QUERY_CANONICAL_SCHEMA_U stored procedure. Before you generate the XSD, verify the following:
  • SYSXML database is installed on the system running the stored procedure. If the database is not installed, the command option does not appear in the SQL Editor menu.
  • You have permission to execute the SYSXML stored procedure. If you do not have permission, an error returns.
You can select individual SQL statements from the SQL file window and invoke the Generate XML Stylesheet command on single statements. If multiple SQL statements are passed to the command, you are asked if you want to continue by choosing only the first SQL statement. Also the command does not support statements that use parameter substitution.