Return data type of aggregate function

Asked By 200 points N/A Posted on -
qa-featured

Good day,

I am working on converting windows applications, so it can be used with SQL server and Informix database. In a SQL server, the return data type of the SUM () function is the same as the data type of the column begin summed. So, if I sum integer field I get integer data type. It appears in Informix, that no matter what I SUM (), I get a float data type.

I have two questions:

1-Is there a setting that could change this?

2-What other aggregate functions does this apply to?

 

Thank you in advance for your help.

Regards.

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 0 points N/A #84933

Return data type of aggregate function

qa-featured

Yes there are other settings as well.

You may try these too.

1. This link gives the details of settings that may help you.

2. You can manually change the settings as well Check this link

The above mentioned link will help you if you want to change them manually and you can apply the stuff mentioned above.

This will surely help you.

So far as the second question is concerned, well there is a function called NULL function, it indicates it is in SQL and it's like a special marker and represents the missing information.

It was created by the relational database team.

About Eric-Jones
Questions
0
Answers
5
Best Answers
4
  • Posted on -
  • Question Category:

Better Performance of DISTINCT and GROUP BY

Previous

IeXplore caused a stack fault in module Wsock32.dll

Next

Related Questions