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
Received on Mon Nov 19 2007 - 13:13:34 CST
