Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Feb 2003 @ 18:03:14 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: User Queries holding out Batch
From:   Belle, Patrick A

JF writes:

  We have a standard that before multiloading to a permanent table, we always run a Release Multiload.  

Doing this as a routine and automatic process would frighten me. I'm assumijng that you have the release imbedded in the script that runs the multiload. If that's the case, you would need a separate script (without the release) to recover from errors by restarting the Mload. Remember that if the failure occurs in the apply phase, the release may simply give you access to a corrupted table!

Pat Belle
Teradata Certified Master

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020