Archives of the TeradataForum
Message Posted: Thu, 24 Oct 2002 @ 09:02:45 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|