A ResultSet to XML demux transform pipeline item is a demupltiplexer that takes a result set as input and generates a sequence of SAX event streams as output. A new SAX event stream will be generated for each row in the result set and the form of the XML generated is much like the one generated by the ResultSet to XML Pipeline Item:
<result> <row count="1"> <COLUMN_NAME_1 type="1">COLUMN_VALUE</COLUMN_NAME_1> <COLUMN_NAME_2 type="1">COLUMN_VALUE</COLUMN_NAME_2> ... <COLUMN_NAME_N type="1">COLUMN_VALUE</COLUMN_NAME_N> </row> </result>
For each row, the column names are used as element tags, and the java.sql.Types
value for the type is added as an attribute. All columns in the result set participate
in the output.