Archives of the TeradataForum

Message Posted: Wed, 05 Jan 2011 @ 10:56:31 GMT

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

Laxmi Kantha K wrote:

Decimals are stored as scaled integers:

1..2 digits: 1 byte

3..4 digits: 2 bytes

5..9 digits: 4 bytes

10..18 digits: 8 bytes

19..38 digits: 16 bytes

You can change the definition of a decimal only if:

1. the number of fractional digits doesn't change

2. the number digits increases

3. the internal storage size doesn't change

Changing dec(9,2) to dec(15,2) breaks #3, thus you can't do it.

Dieter

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