Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 24 Oct 2002 @ 09:02:45 GMT


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


Subj:   Extract function in view
 
From:   Robert Doss

When I use the extract function in a view:

(e.g. EXTRACT(DAY FROM mydate))

the parser rewrites the expression as:

(EXTRACT (DAY FROM (mydate (DATE)))(TITLE 'DayOfMonth'))

and in the process it also strips all the non-display characters out of the view def (line feeds etc...) so when I do a show view the view is very ugly.

Also I've learned not to use extracts repeatedly in case expressions etc.. because it can really expand the size of the view.

Anyone know how to turn this feature off?


Thanks in advance.

Bob Doss



     
  <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