Archives of the TeradataForum
Message Posted: Fri, 04 Feb 2005 @ 12:07:47 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|