Question
Is it possible to roll back the records that an error occured and commit only the records that no error occured in Execute Update SQL?
Answer
It is possible by combining Execute Update SQL, Loop by Number of Data and Monitor Exception.
By passing input data in each record from Loop by Number of Data to Execute Update SQL in the process of Monitor Exception, only the records that no error occured is committed.
Loop by Number of Data
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/flow_loop_by_number_of_data.htm
Monitor Exception
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/flow_monitor_exeption.htm
Comments
0 comments
Article is closed for comments.