Archives of the TeradataForum

Message Posted: Tue, 22 Jun 2004 @ 14:06:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Prasanna:

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:

     sel col1+.000000000000000001(dec(10,10))

Hope this helps,

Michael Larkins
Certified Teradata Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>