Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: About RoundHalfwayMagUp in BTEQ Session Level
From:   Michael Larkins


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019