InterviewSolution
Saved Bookmarks
| 1. |
What is the importance of coding COMMITS in batch programs? |
|
Answer» COMMIT STATEMENTS are used for releasing LOCKS that are needed for that particular work unit and then allow new work units. In case, COMMITS are not part of the program, then during processing of the program, it has to GO back to the inserts that were made during the program RUN instead of going back to few inserts near the most recent commit. This process takes 2 or 3 times extra time than the time taken for program execution. |
|