ID

Uploaded

Status

Description

Work Items

Action

9088
by MarkATerry
Apr 8, 2011
12:19 PM

Being evaluated

When loading decimal numbers less than 1 into a decimal field with more precision available than is the number being loaded has, the number is reduced by a factor of 10 (the actual factor is the difference between the scale in the schema and precision of the value).

E.g. Loading the value 0.0001 into a column defined as decimal(18,12) results in the value 0.000000000001 in the database.

It's a one line fix in TdBulkCopy to put it right:

value = System::Decimal::Multiply(value, System::Convert::ToDecimal(System::Math::Pow(10, point - sourceColumns[i]->Scale)));
<<
value = System::Decimal::Multiply(value, System::Convert::ToDecimal(System::Math::Pow(10, System::Math::Abs(point - sourceColumns[i]->Scale))));

Download

6708
by crispy_b99
Sep 10, 2010
6:24 AM

Declined

Test program using the TdParallelTransport
1. Create table using tablescript.sql
2. Create ODBC connection using Teradata driver.
3. Adjust password, userid, database name, etc.
4. Run program

I was loading 0.5 millions rows in about 15 seconds.........


Declined Sep 10, 2010: Wrong place.....

View All
  • 1-2 of 2 Patches
    • Previous
    • 1
    • Next
    • Showing
    • All
    • Patches