Archives of the TeradataForum

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

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

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>>