Ah, output. There are two basic forms of the XMLOut tag – we’ve utilized generic versions to demonstrate the “appendTo” functionality, which is missing from query.xml:
<sql:XMLOut var="ResultSet" /> <sql:XMLOut appendTo="ResultSet" var="AdditionalData" />
Because SQLXML is treated as a function, you can only have one XMLOut of the upper variety. Only one variable can be output at the end – the variable specified by the “var” tag. The lower variety of XMLOut is utilized to overcome the problem of when you have multiple variables needing to be output; they can appended to the output stream of the main output variable.
In the context of the eiPlatform, the output variable is automatically broken up by the Database Polling SQL Listener, so that each Record within it becomes its own transaction.