Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 20 Aug 2001 @ 15:32:05 GMT


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


Subj:   Maintaining Volatile Tables
 
From:   Carmen Hofmann

Hello everybody!

Here is a question about managing the number of volatile tables within an application.

We've got a java applet which builds something like a tree view out of data that come from our Teradata DW. For every step there are volatile tables created and we have to make sure not to exceed the limitations of Teradata (not more than 64 VTs for one session).

So it is necessary to drop certain volatile tables since the user navigates through the tree.

The names of the tables are generated dynamically and nowadays the application just terminates, when 64 tables are reached.

How can I maintain the number of volatile tables? My only idea is, to write something like a log file, that contains the names of all volatiles tables. I would prefer a simpler solution, best SQL-based...

Thanks in advance, Carmen.



     
  <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: 27 Dec 2016