DB2 Version 9.7 for Linux, UNIX, and Windows

RetryOnError CLI/ODBC configuration keyword

Turns on or off the CLI driver's error recovery behavior.

db2cli.ini keyword syntax:: RetryOnError = 0 | 1
Default setting:: Allow the CLI driver to attempt error recovery on non-fatal errors.
Usage notes:

By default, CLI will attempt to recover from non-fatal errors, such as incorrect binding of application parameters, by retrieving additional information on the failing SQL statement and then executing the statement again. The additional information retrieved includes input parameter information from the database catalog tables. If CLI is able to recover successfully from the error, by default, it does not report the error to the application. The CLI/ODBC configuration keyword ReportRetryErrorsAsWarnings allows you to set whether error recovery warnings are returned to the application or not.

Important: Once CLI has successfully completed the error recovery, the application may behave differently, because CLI will use the catalog information gathered during the recovery for subsequent executions of that particular SQL statement, rather than the information provided in the original SQLBindParameter() function calls. If you do not want this behavior, set RetryOnError to 0, forcing CLI not to attempt recovery. You should, however, modify the application to correctly bind statement parameters.