Home Page for the TeradataForum

Archives of the TeradataForum

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

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