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:
If you invoke the constructor in a client, specify a server parameter that identifies the Adaptive Server to be used when evaluating the query. The query is evaluated in the Adaptive Server, but the XML document is assembled in the client.
If you invoke the constructor in the Adaptive Server, specify a null value or jdbc:default:connection for the server. The query is evaluated in the current server and the XML document is assembled there.