Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 04 Sep 2008 @ 10:23:15 GMT


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


Subj:   Re: How Can I Avoid Repeating an Expression?
 
From:   Baker, Andy

Phil

The other reason why I put the extra brackets in as a matter of course is that if there is casting or formatting (eg converting a dec to char with format) involved as well as naming then I usuallyy find it is necessary to ensure that all of the actions are completed and instantiated before going forward. In some circumstances (particularly when exporting from Bteq etc field mode vs record mode etc) one can run in confusing results (different output from what was used in the SQL) but . . .

So, I just always go belt and braces.


Regards

Andy Baker



     
  <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