Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 04 Feb 2005 @ 12:07:47 GMT

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

Subj:   Re: Workarounds for Decimal18+
From:   Anomy Anom

<-- Anonymously Posted: Friday, February 04, 2005 07:03 -->

Issue: how to store values that exceed the "Decimal" Type's capabilities. In addition to storing the value as CHAR (perfect for display only) or Float the number could be stored as 2 values. The first value might represent values above the trillions, the second could represent everything to the right of the trillions place (postion 13) and any decimal component.

All the operations done on the value would be in the form of F(value-1) + F(value-2). Also, any carrys outside the range of value-2 would have to be added to value-1. This could become real complicated and would not be obvious to a new user or support Staffer, but it does work.

Good Luck,

  <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: 15 Jun 2023