- 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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.