If objects in your DB2^® database contain columns of data type XML, you can apply an XML transformation to the XML data, and then view and process the transformed XML data in the HTML Visualizer window. You can also transform XML data that results from running DB2 SQL procedures or functions.

Requirements:

• The data in a DB2 table or view, or that data that results from running a DB2 routine must be displayed in the Data view of the IBM Data Designer.
• At least one column of the result data must be of type XML.

To transform the XML data in a column:

1. In the Options section of the Data view, determine the row of the grid that represents the column of XML data that you want to transform.
2. Click the Transform cell in that row of the grid, and then click .

   The Transform window opens.

3. Specify the XML transformation (XSL or XSLT) that you want to apply to the column of XML data. Either type the transformation text, or click Open File to browse to and select the XSL or XSLT file that contains the transformation text.
4. Click OK in the Transform window.

See Also

IBM Data Designer | Reviewing XML Data in DB2 Tables and Views | Running Procedures or Functions | Changing XML Data in DB2 Tables and Views | Deleting XML Data from DB2 Tables and Views | HTML Visualizer

.NET Development Forum   DB2 FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.