This function outputs one or more columns of XML. You can transform the XML to HTML, which is easier to view—see Reports.
| Column | Data Type | Description |
|---|---|---|
| partno | INTEGER | [Appears one or more times.] Index of table. Index of first row is 1. Additional rows appear, with each successive index incremented by 1, only if XML string exceeds 31K. |
| XML | VARCHAR(31000) | XML string representing decision tree model in Predictive Model Markup Language (PMML). To extract XML into viewable format, run following query. |
SELECT XMLSERIALIZE(Content X.Dot) as XMLText FROM (SELECT * FROM "outputdatabase"."outputtablename") AS C, XMLTable ( '//*' PASSING CREATEXML(C.sqlpart) ) AS X ("Dot");