Archives of the TeradataForum
Message Posted: Tue, 22 Jun 2004 @ 14:06:36 GMT
The RoundHalfwayMagUp flag is at the system level in the DBS Control record. If you do not like the way it works, is it possible that no one else likes it either? If this is the case, change the setting to 'Y'. Then everything a exactly .5 will round up.
Otherwise, a work-around would be to add a decimal value so small that it would never change your actual data value, but enough to cause all values that were exactly halfway (.5) to round up. In other words, if you had a column called col1 defined as dec(12,12)and you wanted .000000000050 to round to .0000000001 instead of .0000000000, then you could do the following:
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|