WebSphere Message Brokers
File: ar37650_
Writer: Cerys Giddings

Task topic

This build: July 31, 2007 21:36:47

Creating a submap to modify a database

Use the Create New Database Submap wizard to create a submap to modify a database.

You must have an existing message map from which to call the submap. The following steps describe how to create a submap to modify a database:

  1. In the Broker Application Development perspective, open the calling message map.
  2. In the Source pane, right-click the message component containing the fields to be used to modify the database and click Create New Database Submap. The source can be a wildcard, an element, or an attribute. The Create New Database Submap wizard opens.
  3. If the selected source is a wildcard, select a message or message component for the source wildcard from Select a defined item to replace the source wildcard pane. If you cannot find the message components that you expect, select the Show all resources in workspace check box.
  4. From Select database submap targets expand the database operation that you want to perform. You can select from the following database operations:
    • Table Inserts
    • Table Updates
    • Table Deletes
  5. Select the database tables that you want to map. If you cannot find the Data Targets that you expect, select the Show all resources in workspace check box.
  6. Click OK. A new submap is created with the selected message or message component in the Source pane, and the database table in the Target pane. In the calling message map $db:call is added to the Target pane.
After you have created the submap file, configure the message mappings for the database table.
Related concepts
Message Mapping editor
Mapping node
Message Brokers Toolkit
Related tasks
Creating a new submap
Calling a submap from ESQL
Creating and calling submaps and subroutines
Related reference
Message Mapping editor Target pane
Broker Application Development perspective
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:36:47

ar37650_ This topic's URL is: