SAP Knowledge Base Article - Preview

2629423 - SAP IQ : Aggregate function error appears when using aliasing


Illegal use of aggregate function error appears when using aliasing aggregate like count(*) and using alias in having clause if source table is in IQ or any omni accessed table.

Invalid use of an aggregate function: SQLCODE=-150, ODBC 3 State="42000"



  • SAP IQ 15.4
  • SAP IQ 16.0
  • SAP IQ 16.1


SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4


IQ, having, aggregate , 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 for Me (Login required).

Search for additional results

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