SAP Knowledge Base Article - Preview

2573890 - How to filter out the result of dbisql in IQ.

Symptom

Can I turn off the column name and row count display in dbisql?


(DBA)> select count(*) from table_name
count()
--------------------
1

(1 rows)

Execution time: 0.056 seconds

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.2
  • SAP Sybase IQ 12.7
  • Interactive SQL

Product

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

Keywords

IQ, dbisql, set nocount on, isql, filter, column, result, row count , KBA , BC-SYB-IQ , Sybase IQ , How To

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.