Symptom
The "NOCOUNT" option does not work when connecting from isql to SAP IQ.
When you run "NO COUNT ON" as in the following example, isql's "xx row affected" message is displayed.
isql -U dba -S iqdemo -P Password
set nocount on
go
select @@version
go
@@version
go
-------------------------------------------------------------------------------------------------------------------------------- SAP IQ/16.1.040.1372/13871/P/SP04.04/Linux/Linux64 - x86_64 - 3.10.0-327/64bit/2020-04-29 19:25:57 (1 row affected) <---- This!
Read more...
Environment
SAP IQ all versions
Product
SAP IQ 16.0 ; SAP IQ 16.1
Keywords
IQ, SAP IQ, NOCOUNT, isql, dbisql, affected , KBA , BC-SYB-IQ , Sybase IQ , Known Error
About this page
This 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.