Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Jul 2012 @ 09:37:46 GMT


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


Subj:   Re: What does COMMIT option and TRANSACTION flag
 
From:   Dave Wellman

Hi,

I'm fairly certain...

Transaction Log shows whether you have used the "LOG" or "NO LOG" option for temporary tables. Given that the volatile temp table definition is never stored in the dictionary, this information effectively only applies to global temp tables.

The COMMIT option also applies to VT's and GTT's and documents what was specified for the "on commit" clause. Again, given that the volatile temp table definition is never stored in the dictionary, this information effectively only applies to global temp tables.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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