Re: Zero floats are being unloaded as nulls
Posted in 1998
> David Wrote .... > > >I'm running the following: > >INFORMIX-OnLine Version 7.20.UC3 > >under Digital UNIX V3.2F on an Alpha. > > > >My problem is that the "unload" command generates > >null fields (i.e., "||") for floating-point zero values. > >Since the fields are declared as not null, > >the ensuing "load" fails. > > > >The docs say it's supposed to write "0.00". > >On Solaris, it writes "0.000000e+00" which > >isn't what the doc says but at least it works. > > > >Is there a work-around? An update that fixes this? > >Please reply by email. > >Thanks! > > > >David Anderson > >anderson@icsi.berkeley.edu > > > I had a simmilar problem with Online 7.21 and AIX, in my case it unloaded (-le) instead of zero float. This is a known bug, the solution was to update to Online 7.23. Hope this helps. Tino