WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

Update

The Update transform modifies one or more rows of data in a database table.

Use the Update transform to modify one or more rows of data that match a configured "Where" clause from a database table. Optionally, if no rows of data match your configured "Where" clause, the Update transform can insert a row of data. For more information, see Updating data in a table.

The Update transform performs a single update SQL operation on the configured database server, so the inputs that you connect to your Update transform must provide a single set of data values. If you connect a repeating element to your Update transform, the Graphical Data Mapping editor moves the Update transform into a nested For Each transform.

The database server that is used during the creation of your Update transform is specified in a database definition file (.dbm file) that you select from the Data Design project used to create the map.

When your graphical data map has been deployed to an execution group, and your map is run, the database server that is used by the IBM® Integration Bus runtime component to process your Update transform is specified by a JDBCProvider service. The JDBCProvider service must have the same name as the database that is specified in your Update transform. For more information, see Enabling JDBC connections to the databases.

For information about the Mapping node, see Mapping node.

Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:48:32


Reference topicReference topic | Version 8.0.0.7 | cm40817_