Funny float values (-nan) from unload

I have a table with a couple hundred thousand records in it. Whenever I unload this table with the normal sql unload command, some float values on some records with a 0.00 value get unloaded as the string "-nan" which obviously can't be loaded back into a float column again. This only happens during an unload. Normal selects return a value of 0.00 If I unload these columns as the "(column * 1)" they unload fine as 0.00. Does anybody have any idea where these "-nan" values come from? Currently we have to run a sed script on these load file to "fix" the "-nan" values back to 0.00 Thanks

Looks like a dbaccess bug. Try Jonathan Leffler's sqlcmd. Art S. Kagel JPS wrote: > > I have a table with a couple hundred thousand records in it. Whenever I > unload this table with the normal sql unload command, some float values on > some records with a 0.00 value get unloaded as the string "-nan" which > obviously can't be loaded back into a float column again. > This only happens during an unload. Normal selects return a value of 0.00 > If I unload these columns as the "(column * 1)" they unload fine as 0.00. > Does anybody have any idea where these "-nan" values come from? > Currently we have to run a sed script on these load file to "fix" the "-nan" > values back to 0.00 > > Thanks