Writing an SQL Program › SQL Status Checking and Error Handling

SQL Status Checking and Error Handling

When CA IDMS executes an SQL statement, it returns information about the status of statement execution to a data structure called the SQLCA. Your program should contain logic to handle exceptional conditions resulting from statement execution. This logic takes the form of checking SQLCA information. An alternative to checking the SQLCA is the use of the GET DIAGNOSTICS statement that provides for enhanced diagnostic information.