If the data is correct, redefine the field. In DB2, your best bet is DECIMAL, somewhere between DECIMAL(10) and DECIMAL(31), depending on the size of your data. In other DBMS dialects, use NUMBER(10) or larger.
—
Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)