Archives of the TeradataForum
Message Posted: Fri, 03 Dec 2004 @ 14:59:52 GMT
Teradata has supported volatile and global temporary tables since release 3. A volatile table is materialized in SPOOL. Prior to release 5 you could have 64 volatile tables active at the same time; release 5 takes that up to either 1000 or 2000. You would probably run out of SPOOL before you were able to use this many volatile tables.
Create Volatile Table mytable_vt ... insert into mytable_vt select ... sel * from mytable_vt where ....
Just that easy.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|