In fact, I'm trying to migrate a SQL file from Informix to SAPDB. That's strange, you're right, but this syntax is generated from Informix .... No matter, I changed my SQL file to txr_rate <=99.999.
Thanks. > -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] la part de Arne Gehlhaar > Envoye : mardi 15 juillet 2003 13:14 > A : Anhaus, Thomas > Cc : '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' > Objet : Re: Table creation > > > > The problem is the value of 100 which does not fit into a > number having 2 digits > > to the left of the decimal point (txr_rate_rent decimal(5,3)). > > Please change the constraint ckc_txr_rate_txr to > > CHECK (txr_rate <= 99.999 ) > > Isn't this constraint obsolete then? Because a decimal(5,3) cannot be > larger than 99.999 anyhow !?! > > Arne > > -- > Institute of Shipping Economics and Logistics http://www.isl.org/ > Arne Gehlhaar mailto:[EMAIL PROTECTED] > Universitaetsallee GW1 Block A phone:+49.421.22096.49 > D-28359 Bremen, Germany fax:+49.421.22096.55 > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
