Re: unloading smallfloat-data

Path: emory!sol.ctr.columbia.edu!hamblin.math.byu.edu!hellgate.utah.edu!cs.utexas.edu!qt.cs.utexas.edu!yale.edu!think.com!rpi!ispd-newsserver!kodak!music!amiano From: amiano@music.Kodak.Com (Mitch Amiano) Newsgroups: comp.databases.informix Message-ID: <1991Dec16.172139.18319@kodak.kodak.com> Date: 16 Dec 91 17:21:39 GMT References: <14911@sbsvax.cs.uni-sb.de> <1991Dec13.134143.5189@investor.pgh.pa.us> Sender: amiano@music (Mitch Amiano) Organization: Eastman Kodak Co., Rochester, NY In article <1991Dec13.134143.5189@investor.pgh.pa.us>, rbp@investor.pgh.pa.us (Bob Peirce #305) writes: |> In article <14911@sbsvax.cs.uni-sb.de> becker@ukh840.med-in.uni-sb.de writes: |> >Problems unloading smallfloat - numbers |> > |> >I am storing some laboratory-results as smallfloat-numbers. Now it is |> >necessary to unload data for statistical analyses with SPSS. |> >Data which have been entered into INFORMIX as round numbers |> >lead to unloaded data with many positions after the decimal point. |> > 1.31 ---> 1.3099999 [...stuff from both articles deleted...] |> |> with appropriate rounding. I think Informix actually does this for you |> on things declared as money. If all you need are two decimals you might |> try calling them money. Or use the DECIMAL data type, which is probably the most appropriate type, since you specify the precision of a DECIMAL column to your specific need. ------------------------------------------------------------------------------------ Mitch C. Amiano, Software Contractor Rochester, NY 716-226-2024 amiano@music.kodak.com