Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 16 May 2002 @ 17:54:43 GMT

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

Subj:   Re: Rounding in Teradata
From:   John Street

The flag is this:

Starting with V2R3.0.1, the DBS Control utility has a new field called RoundHalfwayMagUp. This field indicates how rounding should be performed when computing values of DECIMAL type. A halfway value is exactly halfway between representable decimal values.

The rounding behavior is different depending upon the setting of the RoundHalfwayMagUp field.

If you set the field to TRUE, the system uses rounding semantics appropriate for many business applications: l The magnitudes of halfway values are rounded up. Halfway values are rounded away from zero so that positive halfway values are rounded up and negative halfway values are rounded down (toward negative infinity). For example, a value of 2.5 is rounded to 3.

If you set the field to FALSE, the system uses the rounding semantics traditional for Teradata:

l A halfway value is rounded up or down so that the least significant digit is even. For example, a value of 2.5 is rounded to 2.

The default is FALSE.


John Street
Senior Principal Consultant,
Relationship Technology Solutions for Financial Services,
NCR Limited

  <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: 28 Jun 2020