Error Handling

To strengthen error handling, you should consider embedding the SQL WHENEVER directive in your source code. The WHENEVER directive is used to direct program logic when the application encounters a warning or an error. You can choose to ignore errors or redirect them with WHENEVER.

The default behavior of AcuSQL is to attempt to ignore warnings and error conditions, and continue processing, if possible. Your application can either explicitly check error conditions or, for more automatic error processing, use the WHENEVER directive. Your application can contain more than one WHENEVER directive. A WHENEVER directive applies to all embedded ESQL statements that follow it, until it is superseded by another WHENEVER directive.

Use the WHENEVER directive to specify what actions the program takes when it encounters one of the following conditions:

• SQLERROR
• SQLWARNING
• NOT FOUND. This condition applies only to SELECT and FETCH statements.

Specify one of the following actions when an error condition occurs:

• CONTINUE – control passes to the next statement
• PERFORM paragraph_name – the program performs paragraph_name and then returns to read the next statement.
• GOTO paragraph_name – the program branches to paragraph_name, a specified procedure in the program. Flow of the program continues down this branch.
• STOP

EXEC SQL WHENEVER {SQLERROR}   | {CONTINUE}
                  {SQLWARNING} | {PERFORM paragraph}
                  {NOT FOUND}  | {GO TO paragraph}
                               | {STOP}