Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 28 Feb 2003 @ 14:09:18 GMT


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


Subj:   Re: WINDDI, QUERYMAN and BTEQ generate different output for the same query
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, February 28, 2003 08:12 -->

  sum and count in Query man uses Decimal(18) where as sum and >count function in BTEQ utilizes FLOAT datatypes.  



Sorry, but this is mistaken. sum and count are done by the amps, so they're the same for everybody as long as you pass the same sql. If the column that you are summing is float, the result will be float.



     
  <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