DB2 Version 9.7 for Linux, UNIX, and Windows

ServerMsgMask CLI/ODBC configuration keyword

Specifies when CLI should request the error message from the server.

db2cli.ini keyword syntax:

ServerMsgMask = 0 | 1 | -2| -1

Default setting:

CLI will check the local message files first to see if the message can be retrieved. If no matching SQLCODE is found, CLI will request the information from the server.

Equivalent connection attribute:

SQL_ATTR_SERVER_MSGTXT_MASK

Usage notes:

This keyword is used in conjunction with the UseServerMsgSP CLI/ODBC configuration keyword. The keyword can be set to:

0 (default) = SQL_ATTR_SERVER_MSGTXT_MASK_LOCAL_FIRST. CLI will check the local message files first to see if the message can be retrieved. If no matching SQLCODE is found, CLI will request the information from the server.
1 = SQL_ATTR_SERVER_MSGTXT_MASK_WARNINGS. CLI always requests the message information from the server for warnings but error messages are retrieved from the local message files.
-2 = SQL_ATTR_SERVER_MSGTXT_MASK_ERRORS. CLI always requests the message information from the server for errors but warning messages are retrieved from the local message files.
-1 = SQL_ATTR_SERVER_MSGTXT_MASK_ALL. CLI always requests the message information from the server for both error and warning messages.