- 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.
- SAP IQ 12.7
- SAP IQ 15.x
- SAP IQ 16.0
SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7
Msg 2601, Msg 99999, Msg 21, system error, CONDITIONAL , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.