WebSphere Message Broker Basics
message content from the Web material available to download (see
Appendix B, “Code” on page 319).
7. Use the Dequeue wizard to get the output message, which should contain the
same message data as the input message, from the
ESQL_BOOKSTORE_CCA_OUT queue on the same queue manager.
8. Check that the CUSTACCTB table in the BSTOREDB database has been
updated with the information from the input message:
a. Open the DB2 Control Center: Click Start → Programs→ IBM DB2 →
General Administration Tools → Control Center.
b. In the left pane of the Control Center window, expand All Databases →
BSTOREDB, then click the Tables folder. All the tables in the
BSTOREDB database are listed in the top-right pane.
c. Double-click the CUSTACCTB table. The Open Table dialog opens,
displaying the data in the table.
The CUSTACCTB table should contain a row of data for each time you put
a message through the ESQL_Create_Customer_Account message flow.
d. Try changing some of the field values in the input message in the
ESQL_Create_Customer_Account.enqueue file (for example, change the
name of the customer and the customer’s password), then put the
message through the message flow. Another row is added to the
CUSTACCTB table with the values that you entered in the input message.
9. Create a new enqueue file called ESQL_Book_Order.enqueue in which to put
the message in Example 4-7 on page 85. You can copy the message content
from the Web material available to download (see Appendix B, “Code” on
10.Use the Dequeue wizard to get the output message, which should contain the
message in Example 4-8 on page 86, from the
ESQL_BOOKSTORE_BO_OUT queue on the same queue manager.
11.Try changing the details in the input message in
ESQL_Book_Order.enqueue; for example, add another book to the order or
change the price of one of the books. Put the message through the message
flow and check the output message to see how your changes affected the
If the message does not output the correct message, or if the message flow
cannot process the message, see Chapter 8, “Troubleshooting and problem
determination” on page 241, for information about problem determination.