Use the Failure transform to handle exceptions that might be raised by the configured database server when your message map runs SQL statements to implement the action of a database transform.
If you want the message map to handle exceptions that are returned from the database server when the SQL operation is run, instead of such exceptions stopping the message map and being reported, you can add a Failure transform to the transform group.
The Failure transform is an optional transform that can be added or removed as required.
The Failure transform does not perform any transformation. You must transform the input and output elements within the nested map.
When you create a database transform, select Treat warnings as exceptions if you want the database warnings to be treated as errors.
If this option is selected, the first SQL operation that results in a warning from the selected database raises an exception.