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.