Retrieve DB2 SQLCA Data › Action Diagramming Statements

Action Diagramming Statements

CA Gen includes two action diagramming statements, WHEN DATABASE DEADLOCK OR TIMEOUT and WHEN DATABASE ERROR, that allows your application to continue processing when a deadlock, timeout, or other database exception occurs. If your application uses these database exception handling statements, it must provide its own logic to roll back previous updates and to ensure data integrity if processing continues.

Important! The WHEN DATABASE DEADLOCK OR TIMEOUT statement is inoperative for applications running under IMS because IMS automatically cancels and rolls back transactions that encounter this type of error, without returning control to the application program.