Archives of the TeradataForum
Message Posted: Fri, 20 Feb 2004 @ 15:24:11 GMT
It would appear that you have exceeded the current size of the parser cache. This cache continues to increase over various releases of Teradata. So, someday it will probably work as written. I realize this is little help now. That's the "bad news".
However, the "good news" is that there is probably a better way in Teradata to do what you want. Teradata, via its parallel architecture, is actually better (faster) at doing a join than it is at comparing several literal values. So, my first attempt at a fix for this would be to put the 50 values that you mention into a table using them as the Primary Index. Then, instead of using a long, involved and maybe complicated CASE, simply join the values to the table to retrieve the data you are looking for in the CASE. Another advantage to this approach is that if the data changes, you update the table one time instead of finding and changing multiple CASE statements.
Just a thought and a possible alternative to your situation.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|