Archives of the TeradataForum

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

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

<-- 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>>