DB2 Version 9.7 for Linux, UNIX, and Windows

IgnoreWarnList CLI/ODBC configuration keyword

Ignores specified sqlstates.

db2cli.ini keyword syntax:: IgnoreWarnList = "'sqlstate1', 'sqlstate2', ..."
Default setting:: Warnings are returned as normal
Usage notes:

On rare occasions an application may not correctly handle some warning messages, but does not want to ignore all warning messages. This keyword can be used to indicate which warnings are not to be passed on to the application. The IgnoreWarnings keyword should be used if all database manager warnings are to be ignored.

If an sqlstate is included in both IgnoreWarnList and WarningList, it will be ignored altogether.

Each sqlstate must be in uppercase, delimited with single quotes and separated by commas. The entire string must also be enclosed in double quotes. For example:

   IgnoreWarnList="'01000', '01004','01504'"