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
In questa pagina del sito puoi guardare il video online Avoid Reprocessing in COBOL-DB2 Cursor Program | Interview Question Explained della durata di ore minuti seconda in buona qualità , che l'utente ha caricato AB tech support 16 aprile 2025, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 411 volte e gli è piaciuto 0 spettatori. Buona visione!
