Archives of the TeradataForum
Message Posted: Tue, 04 Nov 2003 @ 20:30:23 GMT
I am having a problem losing my decimal precision after importing data from Teradata using DTS.
I am using an ODBC connection to Teradata specifying the input as a query. "Select * from flm.VEL_CR_HDR_HIST"
The column on Teradata is defined as type decimal, length 4, format -----.999 & nullable
The column is defined by DTS import on SQL server as numeric with precision 7 scale 3.
The input data viewed thru queryman, WINDDI and even MS ACCESS using ODBC shows 19.07. However, when I look at the DTS test results for the column it shows 19.000. When I execute the import and view the table it shows 19.000
I have tried changing the DTS "select" to use a cast statement as decimal(7,3) but it didn't make any difference.
Can anyone help me? Is there some parameter in SQL server or Teradata that is causing this truncation of the decimal precision?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|