Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 03 Dec 2004 @ 14:59:52 GMT

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

Subj:   Re: Volatile /Temporary Tables in SQL
From:   Michael Larkins

Anomy Anom:

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.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <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: 23 Jun 2019