Retrieving SQLCA Data › Process Continuation During Database Exception

Process Continuation During Database Exception

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

For more information about using these statements in MVS applications, see the Host Encyclopedia Construction User Guide.

Important! The WHEN DATABASE DEADLOCK OR TIMEOUT statement will be inoperative for applications running under IMS on z/OS, because IMS automatically cancels and rolls back any transaction that encounters this type of error, without returning control to the application program.