EnableZOSServerMsgSP IBM data server driver configuration keyword
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 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.