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:
- CLI calls
the stored procedure indicated by the SQL_ATTR_SERVER_MSGTXT_SP connection
attribute. If this attribute is not set, CLIcalls
the SYSIBM.SQLCAMESSAGE stored procedure. If this attribute is set
to DSNACCMG, CLI calls
DSNACCMG when connected to DB2 for z/OS Version
7 servers and calls SYSIBM.SQLCAMESSAGE when connected to DB2 for z/OS Version
8 or later.
- 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.
- DSNACCMG has been deprecated in DB2 for z/OS Version
9 and might be removed in a future release. If SQL_ATTR_SERVER_MSGTXT_SP
is set to DSNACCMG, set this attribute to a different store procedure
to retrieve messages text. Alternatively, use local message files
or use the ServerMsgTextSP configuration keyword.