Chapter 8: Handling Errors

This chapter discusses how to detect and correct errors that can occur during the execution of Embedded SQL programs. It covers the whenever and get diagnostics statements, which you can use to process warnings and errors, and the SQLCA variables that pertain to warnings and errors.

While an Embedded SQL application is running, some events may occur that interfere with the application’s operation. Following are examples:

You can anticipate these events by writing warning and error handling code to recover gracefully when one of these situations occurs.