Avoid Reprocessing in COBOL-DB2 Cursor Program | Interview Question Explained

Publicado em: 16 Abril 2025
no canal de: AB tech support

411

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

Nesta página do site você pode assistir ao vídeo on-line Avoid Reprocessing in COBOL-DB2 Cursor Program | Interview Question Explained duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário AB tech support 16 Abril 2025, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 411 vezes e gostou 0 espectadores. Boa visualização!

5,147

474