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.