I've been reading up on the XML Extender, and found that it will do some of
what I need it to do. What I'm looking to do is have a web server (which is
serving up a web site) query a DB2 database. Once the query is run on the
DB2 machine, I'd like the result set put into XML (in accordance to a
predefined XSD) and send it back to the web server. Once the XML stream
makes it to the web server, it will be parsed and handling as required.
From what I've read (please correct me if I'm wrong), using the XML
Extender, I can put together a stored procedure that will can be enable to
allow overriding of the SQL query based on user input. The procedure
executes and the result set can be put into an XML file using the engineered
DAD. This XML file is then stored in a database table.
Problem is, I don't need the resulting XML to be in the database. I need it
to be sent back to the initiating web server. How can this entire process
work? Has anyone does this before? Are there any examples/tutorials I can