Transforming an XML document with XSLTRANSFORM

The standard way to transform XML data into other formats is by Extensible Stylesheet Language Transformations (XSLT). You can use the XSLTRANSFORM function to convert XML documents into HTML, plain text, or different XML schemas.

XSLT uses style sheets to convert XML into other data formats. You can convert part or all of an XML document and select or rearrange the data with the XPath query language and the built-in functions of XSLT. XSLT is commonly used to convert XML to HTML, but can also be used to transform XML documents that comply with one XML schema into documents that comply with another schema. XSLT can also be used to convert XML data into formats such as comma-delimited text or formatting languages.

XSLT style sheets are written in Extensible Stylesheet Language (XSL), an XML schema. For information on how to write XSL see the W3C recommendation for XSL Transformations.

The XSLTRANSFORM function accepts an XML document from an expression, an XSL style sheet, and parameter values to the XSL style sheet as input. The XML document is transformed with the instructions in the XSL style sheet.

The XSLTRANSFORM user-defined function is created during installation or migration. The XSLTRANSFORM function requires Java™. Setup is similar to the WLM environment for XML schema repository Java stored procedures.