Database

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-10-2006
02:28 PM

12-10-2006
02:28 PM

Data type for Number(22)

I have a column defined as number(22) in oracle. I need to load the data from oracle to Teradata. What will be suitable coulun data type for Teradata? Can define something like float(22). Is there any restrcition that teradara can't store more than 18 digits for numbers (For Precision)? If so any ideas for this?

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-11-2006
12:59 AM

12-11-2006
12:59 AM

Re: Data type for Number(22)

From V2R6 we have support for decimals with 38 digits. It is called Large decimal. The below is its description.

A large DECIMAL is a DECIMAL data type whose maximum precision is 38. A DECIMAL data type with this increased precision can be used anywhere the DECIMAL data type with 15 or 18 digits can be used. Applications that require the computation of figures in excess of 18 decimal digits are able to do so directly within the database. A large DECIMAL is stored in 16 bytes with the least significant byte first.

Alternately,you can define the column to have floating point representation i.e., define column as float.

A large DECIMAL is a DECIMAL data type whose maximum precision is 38. A DECIMAL data type with this increased precision can be used anywhere the DECIMAL data type with 15 or 18 digits can be used. Applications that require the computation of figures in excess of 18 decimal digits are able to do so directly within the database. A large DECIMAL is stored in 16 bytes with the least significant byte first.

Alternately,you can define the column to have floating point representation i.e., define column as float.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

12-11-2006
12:19 PM

12-11-2006
12:19 PM

Re: Data type for Number(22)

Large Decimal is only available in V2R6.2 or later.

In earlier releases you cannot have more than 18 digits precision in numeric fields. FLOAT has much larger range, but less precision.

In earlier releases you cannot have more than 18 digits precision in numeric fields. FLOAT has much larger range, but less precision.