unloading smallfloat-data

Posted in 1991

Walt Hultgren {rmy} — Mon, 9 Dec 91 10:45:20 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!swrinde!cs.utexas.edu!uunet!mcsun!unido!sbsvax!ukh840!becker From: becker@ukh840.med-in.uni-sb.de Newsgroups: comp.databases.informix Message-ID: <14911@sbsvax.cs.uni-sb.de> Date: 9 Dec 91 09:13:52 GMT Sender: news@sbsvax.cs.uni-sb.de 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 This problem, which is well known in programming environnement, induces a growing of the unload - file and to unwanted output of the statistics. Naturally, there is a way to avoid this: use of filters like awk,... but I think this is a wrong behavior of INFORMIX. Dieter -- Dr. med. dipl.-math Dieter Becker Tel.: (0 / +49) 6841 - 16 3046 Medizinische Universitaets- und Poliklinik Fax.: (0 / +49) 6841 - 16 3369 Innere Medizin III D - 6650 Homburg / Saar Email: becker@med-in.uni-sb.de