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.
- 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.