ServerMsgTextSP CLI/ODBC and IBM data server driver configuration keyword

Specifies which stored procedure is used to retrieve message text from Db2 for z/OS.

db2cli.ini keyword syntax:: ServerMsgTextSP = stored procedure name
IBM data server driver configuration file (db2dsdriver.cfg) syntax:: <parameter name="ServerMsgTextSP" value="stored procedure name"/>

Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.

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 and IBM data server driver configuration keyword to indicate when CLI should call this procedure to retrieve the message information from the server. If the ServerMsgMask CLI/ODBC and IBM data server driver configuration keyword is not set, then the default is to check the local message files first. See the ServerMsgMask CLI/ODBC and IBM data server driver configuration keyword for more details on the options available.; The difference between ServerMsgTextSP and UseServerMsgSP CLI/ODBC and IBM data server driver 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.