1964769 - ON_TSQL_ERROR database option behavior not as documented - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1964769 - ON_TSQL_ERROR database option behavior not as documented - SAP IQ

Symptom

  • The SAP IQ database option ON_TSQL_ERROR controls error handling in stored procedures for the purpose of establishing behavior compatible with ASE. The default setting is CONDITIONAL.
  • It is set to CONTINUE by the system stored procedure sp_tsql_environment for every T-SQL login. With the CONTINUE setting, IQ should execute additional statements after encountering an error, typically to raise a user-defined error message. Instead, processing stops.
  • A T-SQL login uses the TDS communications protocol and comes from a jConnect or Open Client connection. Open Client isql is an example of a TDS-based utility, commonly used with IQ for command processing. Applications connecting with ODBC are not affected by this.

Read more...

Environment

  • SAP IQ 12.7
  • SAP IQ 15.x
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

Msg 2601, Msg 99999, Msg 21, system error, CONDITIONAL , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.