Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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.


Andy Baker

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020