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.