Very Computer

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
reference?

Thanks,
bort

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries

Quote:>>> www.iseries.ibm.com/db2

--Tracy

I'll give it a read and see what I find out...

Thanks,
bort

Quote:> Bort,
> I think what you want can be accomplished using the MQSENDXML function,
> described in the DB2 UDB V8 XML Administration and Programming Guide.
> This function can be used to send the content of a column to an MQ
> Series message queue (an XML document generated by XML Extender) which
> can then be picked off at the Web server end.

> --Tracy