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

Publicado el: 16 abril 2025
en el 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

En esta página del sitio puede ver el video en línea Avoid Reprocessing in COBOL-DB2 Cursor Program | Interview Question Explained de Duración hora minuto segunda en buena calidad , que subió el usuario AB tech support 16 abril 2025, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 411 veces y le gustó 0 a los espectadores. Disfruta viendo!

5,147

474