Load/Unload problems

Hello: I have this strange problem and I hope that someone could give me a hint. --- On-Line 7.21 AIX 4.2 (Using dbaccess) --- CREATE TABLE t1 ( col1 CHAR(1), col2 FLOAT) INSERT INTO t1 VALUES ("1",0.0) INSERT INTO t1 VALUES ("2",1.0) UNLOAD TO t1 SELECT * FROM t1. The unloaded file contains 1|-le| 2|1.0| If I try to load this file and insert the data into t1 the system complains because (-le) is not a valid float number. This happens only when I have 0.0 as data. SELECT * FROM t1 works great. any hints?? please email me your suggestions, I do not have permanent access to a news server ccremid@saadev.saa.noaa.gov Thanks in advance Tino -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet