Error Handling in Embedded Applications
SQL provides a variety of tools for trapping and handling errors in embedded SQL applications, including:
• SQLCA
• SQLSTATE
• The WHENEVER statement
• Handler routines
• INQUIRE statements
• The IIseterr() function