Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 01 Aug 2002 @ 12:41:53 GMT


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


Subj:   Re: Volatile table & VB
 
From:   Geoffrey Rommel

  The default to delete the rows is I believe an ANSI standard and not Teradata specific,  


Yep.

"If TEMPORARY is specified and ON COMMIT is not specified, then ON COMMIT DELETE ROWS is implicit." (SQL Foundation, Vol. 2, ISO/IEC 9075-2:1999, sec. 11.3, rule 12, p. 407)


  but stupid (in my humble opinion).  


I agree!


--wgr



     
  <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