Specifies whether a stored procedure is used to retrieve
message text from the DB2® for z/OS® server.
- Equivalent CLI keyword
- UseServerMsgSP
- Equivalent IBM® Data Server
Provider for .NET connection string keyword
- None
- db2dsdriver.cfg configuration syntax
- <parameter name="EnableZOSServerMsgSP" value="0 | 1 "/>
- Default setting:
- The DB2 application 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 EnableZOSServerMsgSP 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.
- The DSNACCMG procedure is deprecated in DB2 for z/OS Version
9 and might be removed in a future release. If the SQL_ATTR_SERVER_MSGTXT_SP
attribute is set to the DSNACCMG procedure, set this attribute to
a different store procedure to retrieve messages text. Alternatively,
use local message files or use the ServerMsgTextSP configuration
keyword.