Teradata Forums / Teradata / Training / Number Data Type / Latest Posts

RE: Number Data Type

marcmc — Wed, 04 Jul 2007 08:55:37 GMT

deleted a mis directed thread. can't see a delete option. apologies.

RE: Number Data Type

Fred Pluebell — Sun, 28 Jan 2007 13:09:41 GMT

Teradata V2R6.2 (not 6.1.x) supports BIGINT and DECIMAL(38,x) datatypes. Never use FLOAT unless approximate values are acceptable.

In earlier releases, possible workarounds include using a smaller field such as DECIMAL(18,x) if that will hold the actual data values, storing the data in separate "high order" and "low order" fields and combining them in your application, or storing the data in character form. In the latter two cases you may be able to define UDFs to simplify working with the data.

RE: Number Data Type

rakeshroshanjha — Sat, 27 Jan 2007 15:17:35 GMT

We have decimals which have max size of (18,18) in V2R6 1.0.1 and (32,18) in V2R6 1.1.1
Other than that, we have Floats which can manage anything above 18.
Integer can accomodate only 2Billion of values.
Number(10) in oracle is Decimal(10,0) in teradata.

Hope u got it

Number Data Type

rajgowda — Thu, 01 Dec 2005 06:40:54 GMT

Hi

I am loading data from oracle to Teradata table, one of the source column having data type Number in oracle which contains data having length of 30 digits.In Teradata for the same column the datatype is INTEGER.Integer accomodates maximum length of 8 digits.

Is there any other data type I can use for this to store length of 30 digits in Teradata.I have tried with decimal, even decimal is having limitation of 18.

Thanks,
Gowda