The select ... for xml statement and the Java-based SQLX mapping functions map a single SQL result set to a SQLX-formatted XML document. Adaptive Server provides a Java-based SQLX mapping function, forxmlmultiplej, that maps multiple result sets of a SQL query to an XML document.
