SAP Knowledge Base Article - Preview

1989852 - Count() function returns the result of unsigned bigint - SAP IQ

Symptom

  • Document explains as Count () function is returned INT. However, Count () function is used unsigned bigint.
  • SAP IQ 16.0 SP03 - Reference: Building Blocks, Tables, and Procedures - 'SQL Functions - Alphabetical List of Functions':

COUNT Function [Aggregate]
     Counts the number of rows in a group, depending on the specified parameters.

Syntax
     COUNT ( * | expression | DISTINCT column-name )
...
...
Returns
     INT

 


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.x

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

Count, int, CR759565, 759565 , 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.