Hi!

I'm working on converting a Windows application so it can be used with SQL-Server and Informix.

In SQL-Server the return data type of the SUM() function is the same as the data type of the column being summed. So, if I sum an integer field I get an integer data type.

It appears, in Informix, that no matter what I SUM(), I get a float data type.

This matters in my application as the data type must be know ahead of time.

My questions are:

1) Am I right about the returned data types?
2) Is there a setting that could change this?
3) What other aggregate functions does this apply to?

Thank you in advance for your help.

Kind regards,

Mike