I have a requirement where i need to read data from 4 standard tables then write the entries to 4 Ztables then delete the entries from the standard tables.
the sequence is read a standard table write it to ztable then delete the entries from standard table.
this occurs 4 times since 4 table are read and written into a ztable.
but all work should rollback if an error occur.
but currently when the 3rd table write fails when executed rollback work the 1st and 2nd table work has not been rollbacked is there anyway that i can achieve this requirement