Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2002 @ 22:30:48 GMT

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

Subj:   Re: UPDATE Statement from another table
From:   Matt Lipke

Mike L.,

We have had some issues around using the CREATE TABLE AS, such that it will restart the Teradata if we try to use it. So we are staying away from that option. It really does not apply anyway, we are updating different columns from different processes and don't want to stomp on each other as much as possible. Plus we have the NCR CRM tool using "dirty reads" on the tables.

Matt L.

  <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: 28 Jun 2020