AnsweredAssumed Answered

How to maintain transaction when inserting into multiple tables

Question asked by amudhavani.shanthosh181426 on Sep 4, 2017
Latest reply on Sep 5, 2017 by Adam Arrowsmith

Hi All,


Database : IBM DB2 AS400/iSeries


My requirement is into INSERT into 5 tables. If there is any error in INSERT in any of the table INSERT, the other successful INSERTS in other tables, should be rolled back and there should be no INSERT made to any of the tables.


Please let me know the best design approach to achieve this scenario. Thanks.