Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2007 @ 15:30:01 GMT

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

Subj:   Re: Decimal (18,0) magic
From:   Dempsey, Mike

SQL Assistant can only display numerics up to 15 digits of accuracy.

If you want to see full accuracy for an 18 digit number (or 38 digit) you must select the option to 'Display full accuracy...' on the Answerset tab of Options. This will return the data as a character string and it will therefore maintain full accuracy. (Note that the column may not sort correctly unless you also check the sub-option to pad the data values with blanks.)

Mike Dempsey
Teradata Client Tools

  <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: 15 Jun 2023