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
- 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 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 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 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.