Composing a ResultSet XML document from the SQL data

You can use Java methods to evaluate a given query and generate an XML result set with the query’s data. This example uses a constructor method of the ResultSetXml class. For example:

new xml.resultset.ResultSetXml
 	(“select 1 as ‘a’, 2 as ‘b’, 3 ”, “none”,
 	“yes”, “antibes:4000?user=sa”);

The method uses internal JDBC operations to execute the argument query, and then constructs the XML ResultSet for the query’s data.

We can invoke this constructor in a client or in the Adaptive Server: