Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 04 Nov 2003 @ 20:30:23 GMT


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


Subj:   Using SQL server DTS and Teradata
 
From:   Shirley McArdle

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?


Thanks

Shirley McArdle
Fleming Estate



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016