Specifies which stored procedure is used to retrieve message
text from DB2® for z/OS®.
- db2cli.ini keyword syntax:
- ServerMsgTextSP = stored procedure
name
- Default setting:
- CLI does not use the server stored procedure to return messages,
but uses the local message files.
- Equivalent connection attribute:
- SQL_ATTR_SERVER_MSGTXT_SP
- Usage notes:
- Applications using this keyword should also set the ServerMsgMask CLI/ODBC configuration keyword to indicate when CLI should call this procedure to retrieve the message information
from the server. If the ServerMsgMask CLI/ODBC configuration keyword is not
set, then the default is to check the local message files first. See
the ServerMsgMask CLI/ODBC configuration keyword for more details on the options
available.
- The difference between ServerMsgTextSP and UseServerMsgSP CLI/ODBC configuration keyword is that UseServerMsgSP can be turned on and off to call the procedure specified in the
SQL_ATTR_SERVER_MSGTXT_SP connection attribute, while ServerMsgTextSP needs to have the procedure explicitly specified.