Re: Number datatype help?

From: <fitzjarrell_at_cox.net>
Date: Mon, 19 Nov 2007 11:22:27 -0800 (PST)
Message-ID: <2f885f75-c9f7-42e3-9db6-14ae8518f9ca@f3g2000hsg.googlegroups.com>

On Nov 19, 1:13 pm, Serge Rielau <srie..._at_ca.ibm.com> wrote:
> CK wrote:
> >> You first number has 8 digits of precision and a scale of 2 so you
> >> need to declare it as (8,2) rather than (6,2). A format of (6,2)
> >> would support only digits to the left of the decimal point
>
> > Close but it still accepts 654321.000 and it should not. Any other ideas?
> > Thanks for your help.
>
> May I ask WHY it should not accept it?
> Truncating zeros to the right of the decimal point is not typically
> considered data loss...
>
> Cheers
> Serge
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab

Granted it's a poor example, however I believe the OP wishes to reject any number with 3 decimal places, regardless of value, so that 606060.606 would be rejected as would any submission with 3 digits to the right of the decimal. Apparently his x.000 submission was intended for illustrative purposes only.

David Fitzjarrell Received on Mon Nov 19 2007 - 13:22:27 CST