Have Geek Brain

How to use genxmlquery function for Informix using JDBC?

I need to extract the result of a database query in XML format. I was planning to use JDBC as my programming language. I came across IDS 11.0 XML publishing feature and was planning to use it. You have configured your database options for XML publishing and can run a command line query (dbaccess databasename -) and get XML output. I don't know how to use genxmlquery in JDBC. Someone please help me in this regard.

I used the following line on the command line and got the xml output:

 EXECUTE FUNCTION genxmlquery('newquery','select * from site_info');

I don't know how to do the same using JDBC.

+1


a source to share


1 answer


Treat the assertion as if you were executing a SELECT statement in JDBC - after all, it returns data. You will probably get the data (XML document) into an LVARCHAR or Smart Blob host variable.



0


a source






More articles:


All Articles