Return data type of aggregate function

Asked By hkody91 200 points N/A Posted on - 07/22/2011

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.

• Status: Open
• Question Views: 1599
• Answer Count: 1
• Vote Up 20 Vote Down

• Answer Accepted: No
• Question Category: Informix

Answered By Eric-Jones 0 points N/A #84933

Return data type of aggregate function

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

• Vote Up 0 Vote Down

• Posted on - 07/25/2011
• Question Category: Informix