Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Billski — — source: Informix-list mailing list archive (1991-1998)
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.