Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2011 @ 21:18:41 GMT

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

Subj:   Re: Indented Bill of Material Query?
From:   Geoffrey Rommel

  Why engineering implemented the CREATE VOLATILE/GLOBAL temp tables with the default NOT to preserve rows has always been beyond me - probably a dumb ANSI standard?  

Yes, it is an ANSI standard. The underlying idea seems to be that the volatile table will only be needed during the course of a transaction (i.e. until COMMIT) and thus should be empty when the next transaction begins. I submitted an ER once asking to make ON COMMIT PRESERVE ROWS the default for Teradata mode, but it apparently went nowhere.

  <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: 15 Jun 2023