Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 26 Feb 2007 @ 09:22:59 GMT

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

Subj:   Re: Alter Table from Datype date to timestamp
From:   D silva, Joseph Vinish

  The Alter Table SQL statement applies changes directly to the subject table and does not use the Transient Journal at all.  

  In the event of some failure the Alter would be continued from the point it left off after re-submission.  

That's true for Alter table statement. But the original post was about not being able to alter the data types directly (Date -> Time stamp), so have to go through a phase of add a new column, update it with "converted" values from old col, drop old col, rename new col name to old col name.

So the update is definitely a killer in terms of TJ.

Joseph D'silva

  <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