Generating XML documents from existing tables and sending them to an MQ message queue

You can send data from a Db2 table to the MQ message queue. First put the data in an XML document and then send that document to the message queue.

Procedure

To generate XML documents from existing tables and send them to an MQ message queue:

  1. Compose an XML document by using the Db2 XML publishing functions.
  2. Cast the XML document to type VARCHAR or CLOB.
  3. Send the document to an MQ message queue by using the appropriate Db2 MQ function.