Re: decimal defaults

Assuming that you are running either DB-Access or ISQL, the basic answer is that it is fixed in the display code and it is pretty much unchangable. You can try setting DBFLTMASK to an integer number of digits after the decimal point, but my experience is that it's flaky (assume 5.00 or earlier experience -- it could have improved since then!), and you still run into problems if you have extremely large or extremely small values in a column. Your best bet is to use the ESQL/C formatting functions -- I have code which uses the obscure dececvt() and devfcvt() functions to format number in scientific or fixed point formats regardless of scale and precision, etc. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: walm@icsware.com (Wendy Alm) >Date: Wed, 17 Jul 1996 22:41:36 GMT >X-Informix-List-Id: <news.26269> > >We have a query which consecutivly divides non null and non zero >numbers. However, it always returns the answer with only 2 decimal >places. We cannot figure where this default is set. If anyone has an >idea of how to increase the precision, please let me know. My e-mail >address is walm@icsware.com. Thanks for any and all help........ >Wendy