Avoid Reprocessing in COBOL-DB2 Cursor Program | Interview Question Explained
Question: A COBOL-DB2 program is retrieving multiple rows using a cursor. After processing 10 rows, it abends due to an error. What should you do to avoid reprocessing the same rows when the program is restarted?
Options:
A. Restart the program from the beginning
B. Use a COMMIT after every row
C. Use COMMIT after a fixed number of rows
D. Use ROLLBACK after processing 10 rows
Correct Answer: C. Use COMMIT after a fixed number of rows
Explanation:
Using COMMIT after processing a fixed number of rows (e.g., every 10) ensures that only unprocessed rows remain in the cursor if the program fails. This avoids reprocessing already committed rows upon restart. It's a best practice in DB2 programs handling large data sets with cursors.
Subscribe for more mainframe interview tips and programming tricks!
#Mainframe #COBOL #DB2 #InterviewQuestion #Shorts #ABTechSupport
On this page of the site you can watch the video online Avoid Reprocessing in COBOL-DB2 Cursor Program | Interview Question Explained with a duration of hours minute second in good quality, which was uploaded by the user AB tech support 16 April 2025, share the link with friends and acquaintances, this video has already been watched 411 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
