User-Defined Error, Message, and DBevent Handlers offer the most flexibility for handling errors, database procedure messages, and database events. For more information, see Advanced Processing in this chapter.

However, you can do error handling with the SQLCA by using whenever statements or explicitly by checking the contents of the SQLCA fields SQLCODE, SQLERRD, and SQLWARN0.