Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2007 @ 14:14:05 GMT


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


Subj:   Re: Decimal (18,0) magic
 
From:   Tewksbury, Kevin

Not sure about the jdbc, but for SQL go to Tools>Options>AnswerSet tab and you should see a box for "Display full accuracy for Decimal(16) and above". Make sure this box is checked and you should get the correct number. Also note, that in BTEQ the answer set comes back as:

                       a
     -------------------
     222222333333444444.

This indicates to me that the decimal is being converted to possibly hex or something in jdbc and odbc (unless you do the above for SQL Assistant)


KRT



     
  <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: 28 Jun 2020