Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 May 2003 @ 14:20:06 GMT


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


Subj:   Re: Size of count(*) field
 
From:   Walter, Todd A

It is actually quite easy to fix. There's always a but...

If we change it, then most applications which are coded to return count currently will fail when the database release is installed. The failure will occur because the length, type and format of the result will change. Reports will change column layouts, code will have to be changed to receive a different type/length, ...

Everytime we ask, we get a chorus of screams about how painful such a change will be. Note that it is DECIMAL(18,0) in ANSI mode because we could start with it that way on day one.



     
  <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