Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Jul 2002 @ 09:03:25 GMT


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


Subj:   Re: Dec(18,0)
 
From:   Lee Vickers

We have a similar ID field which is DECIMAL(18,0) and this is also a bit dodgy in Queryman. Basically, if you Select it straight from the table, Queryman will do some wierd rounding on the number, consequently, if you copy and paste this number into another query you will get unexpected results. If you want to see it "as it is", then try casting it into a CHAR(20).

This only affects the value of the number displayed not the value 'inside' the SQL. i.e. if you do something like;

SELECT * FROM BBB WHERE BBB.ID_NUM IN (SELECT AAA.ID_NUM FROM AAA);

That will still give you expected results.

Did you copy the '333333333333333500' out of a Queryman answerset? If so, you may find that this record doesn't exist and the actual number is something like '333333333333333521'

LV



     
  <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