Re: INFORMIX 7.1 COUNT(*) QUESTION

halpin,constance a (connie@moscow.cc.bellcore.com) wrote: : My project has just begun testing our application with INFORMIX 7.1 on Pyramid. : We are experiencing a problem with dynamically executed statements : of the form "SELECT COUNT(*) FROM tablename". It appears that the data type of : the returned count value has changed from INTEGER in INFORMIX 6 to DECIMAL : in INFORMIX 7.1. Has anyone else witnessed this change? We can find no documentation : that lists such a change. I have contacted INFORMXIX customer support but have : not yet had a response. : I would appreciate any insight into this problem. : Connie Halpin You are correct. The data type has changed because with the table fragmentation now available in 7.x, the number of potential rows a table may have is significantly increased, and the value would not necessarily fit in a 4 byte integer. Check the release notes in your $INFORMIXDIR/release directory.