Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Sep 2007 @ 15:16:12 GMT


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


Subj:   Re: MultiLoad Delete Failure 2554
 
From:   Michael Larkins

Jesus:

It sounds a bit like the delete with 30 day script was started, and then the script was changed to 60 days (inconsistant restart) in the middle somewhere after an abnormal termination. This will definitely not work. If this is the case, you should have finished the 30 day delete and then run the 60 day delete. Otherwise, Joe's suggestion of totally blowing away the log table, error tables and work table is the other option.

Restarting is often an option depending on the type of changes being made within your Mload script. However, please, please, please never ever consider it the first option. You can leave your data in an inconsistant state, especially when doing updates such as: SET column = column + :invalue


Just a thought and regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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