how do you implement commit work? i have a code more or less like the following:
update db_tab_dtl from table i_dtl. update db_tab_hdr from table i_hdr.
i want to make sure that both statement commits or rollback if atleast one fails. Sort of like the transaction block in SQL...