 |
 |
Archives of the TeradataForum
Message Posted: Tue, 06 Sep 2005 @ 13:59:00 GMT
| Subj: | | Re: Error : 3712 Insufficient memory for Plastic Steps |
| |
| From: | | Victor Sokovin |
| | I am getting error 'Error : 3712 Insufficient memory for Plastic Steps' | |
| | I have a long SQL with many case statements, it runs if I reduce number of case . | |
| | I have increased maxparsetree to 2000 and other related parameter to 1024 in DBSControl but still I get the error .version is V2R5 | |
It sounds like you have hit the memory limit on your system then. The only remedy is to rewrite the query.
If you use CASE to "map" values, you could probably create a reference table with data before and after such a mapping. You could then join
your main table(s) to this new reference table. If this is at all possible in your situation, you'll get more flexible SQL as well: when more
mapping logic is introduced, you might just need to add more rows to the reference table without changing the code.
Regards,
Victor
| |
