Re: problem with dbexport and float fields

On Wed, 17 Feb 1999, Rekaish Bhardwaj wrote: > Hello everyone. > I am having problems with a dbexport > I am exporting a database with a single table with a single row. > The table consists of 77 columns about 60 of which are of type FLOAT. > The single row has a few char fields that are populated with chars > and everyone of the FLOAT fields contains a zero. > I know this because I typed the data in myself. > > I am doing this on AIX 4.1.5 using INFORMIX SQL 6.05 (ONLINE) > The dbexport consistently core dumps when exporting this database. > The unload file produced consists of a single row (as expected) but each > float contains -1e If I remember correctly, it is -le (two letters), but it is a known bug which has been fixed in some versions. Contact Informix Tech Support. The problem is specific to AIX. > If I try unloading this in SQL then each float field contains > 0.000000e+00 (which is what the export should produce) > > I also happen to have a SCO box where this is not a problem > > IS this a bug under AIX. There is nothing in the release notes. Has > anyone else encountered this ?? > comments very welcome Yours, Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn