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
See information about the latest product version
Return
Use the Return transform to report the number of rows that are modified by a database transform.
Use the Return transform in your graphical data map to specify a nested mapping that is called if a database transform was completed successfully.
A Return transform and a Failure transform are automatically created when you create a database transform in your graphical data map. The Return transform is called if the operation that is specified in the database transform is successful, and the Failure is provided to handle database server exceptions. For more information about the Failure transform, see Failure.
The
Return transform provides an in-built input that provides an integer
value of the number of rows that are modified by the related database
transform:
Database transform | Name of input provided by Return transform | Description |
---|---|---|
Insert | NumberOfRowsInserted | The Return transform is called each time that an insert operation is successful, and reports the number of rows inserted as 1. |
Update | NumberOfRowsUpdated | Number of rows updated depends on the WHERE clause |
Delete | NumberOfRowsDeleted | Number of rows deleted depends on the WHERE clause |
For more information, about database transforms, see Mapping database content.
For information about the Mapping node, see Mapping node.