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

Anyone know anything about this?

Thanks,

Mike