Re: Sums of floating point numbers

Don_Jordan writes: > > We are currently running ISQL 4.10 on SCO UNIX System V/386 Release 3.2 > (with plans to upgrade both). I am trying to sum a floating point field in > a view, and seem to have run into the problem that Informix only seems to > want to sum money, i.e., 2 decimal places. My data frequent has 3 or more > preceeding zeros, e.g., 0.0001, so all significance in the sum is lost. All significant digits will display if you set your environmental variable "DBFLTMASK" to "-1", or you can set it to some positive value equal to the number of decimal places you are interested in. -- _____________________________________________________________________ | Colin McGrath cmm@trac3000.ueci.com | | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | | Phila, PA, USA Standard Disclaimers Apply | |___________________________________________________________________|