I am doing UPDATE in two tables in a single program (Program with Checkpoint Restart Logic).
I want to commit the changes after processing five records.So is it reuired to mention two COMMIT
to save the changes in two different table?
My question is - If there are 'n' no. of tables to be updated, is it reuired to give 'n' no. of
Or only one COMMIT is sufficient to save all the changes made to 'n' no. of tables.
Many Thanks in advance.