Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2005 @ 13:59:00 GMT


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


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



     
  <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: 15 Jun 2023