Re: money(16,4) and dbexport

Posted in 1998

Art S. Kagel — Mon, 23 Mar 1998 10:55:03 -0500 — source: Informix-list mailing list archive (1991-1998)

nl@unibest.msk.su wrote: > > Hello all! > > Let's consider the following sequence of actions: > > 1) dbaccess > create database m4; > create table m4 ( isum money(16,4) ); > insert into m4 values( 1.2345 );> > 2) dbexport m4 -o . > > 3) cat m4.exp/m4___00100.unl > 1.23| MONEY columns are assumed to be format 16.2 for conversion to strings as happens in dbexport. Alter the column type to DECIMAL(16,4) and you should have no more trouble. Art S. Kagel