UseServerMsgSP CLI/ODBC and IBM data server driver configuration keyword

Specifies whether a stored procedure is called to retrieve message text when connected to Db2 for z/OS servers.

db2cli.ini keyword syntax:: UseServerMsgSP = 0 | 1
IBM data server driver configuration file (db2dsdriver.cfg) syntax:: <parameter name="UseServerMsgSP" value="0 | 1"/>

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:: If the UseServerMsgSP keyword is set to 1, the CLI driver calls the stored procedure that is indicated by the SQL_ATTR_SERVER_MSGTXT_SP connection attribute. If the SQL_ATTR_SERVER_MSGTXT_SP attribute is not set, the CLI driver calls the SYSIBM.SQLCAMESSAGE stored procedure. If the SQL_ATTR_SERVER_MSGTXT_SP attribute specifies the DSNACCMG procedure, the CLI driver calls the SYSIBM.SQLCAMESSAGE procedure.; Applications that use the UseServerMsgSP keyword can also set the ServerMsgMask CLI/ODBC and IBM data server driver configuration keyword to indicate when the CLI driver calls the SYSIBM.SQLCAMESSAGE 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 DSNACCMG procedure is deprecated in Db2 for z/OS Version 9 servers and might be removed in a future release. If the SQL_ATTR_SERVER_MSGTXT_SP attribute specifies the DSNACCMG procedure, set the SQL_ATTR_SERVER_MSGTXT_SP attribute to a different store procedure to retrieve messages text. Alternatively, use local message files or use the ServerMsgTextSP configuration keyword.