Return
Use the Return transform to report the number of rows that are modified by a database transform.
The Return transform is called if the operation that is specified in the database transform is successful.
Use the Return transform in your message map to specify a nested mapping that is called if a database transform was completed successfully.
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.