Archives of the TeradataForum
Message Posted: Mon, 20 Sep 2004 @ 08:16:13 GMT
This query is more for understanding and confirmation!!!
We are currently using the default value for MaxDecimal i.e. 15. But the aggregate queries are regularly hitting the Numeric overflow for certain applications. We are planning to change the value to 18. I suppose that should increase the maximum limit that the decimal can hold after altering the value.
Can any one tell the maximum value that can be stored in :
In case the value is decimal(15,0), does any one have an alternative to get aggregate results of data currently giving the Numeric Overflow error? (Cast, etc)
Any suggestions are welcome!!!
Thanks & Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|